just checking - Mailing list pgsql-sql

Frompostgresql
Subjectjust checking
Date
Msg-id[email protected]
Whole thread Raw
Listpgsql-sql
At times things seem just too easy, so I want to confirm that this is the 
correct syntax.

I am looking for the interval (aging) for these invoices. I guess I am 
concerned because I guessed at the syntax. Is there a better way to do 
this?

billdate is type 'date'

SELECT ('now'-billdate) FROM fcinvoiced WHERE client = 'smith';

Ted




pgsql-sql by date:

Previous
From: "Albert REINER"
Date:
Subject: Re: How to execute a system file in procedure?
Next
From: Murray Hobbs
Date:
Subject: protected ON DELETE CASCADE