Postgres Pro
Downloads
Home   >   mailing lists

Re: date_part stored procs - Mailing list pgsql-sql

From Tom Lane
Subject Re: date_part stored procs
Date
Msg-id 28231.1080342193@sss.pgh.pa.us
Whole thread Raw
In response to date_part stored procs  ("Tsoloane Moahloli" <tsoloane@mimecast.co.za>)
Responses Re: date_part stored procs  ("Tsoloane Moahloli" <tsoloane@mimecast.co.za>)
List pgsql-sql
Tree view 
"Tsoloane Moahloli" <tsoloane@mimecast.co.za> writes:
>   SELECT INTO len * FROM (SELECT
> ((date_part(''year'',age(docDate))*12)+(date_part(''month'',age(docDate))))
> AS a;
> The problem is that it does not run and I cannot for the life of me tell
> why.    

I think you miscounted parentheses.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Tsoloane Moahloli"
Date:
Subject: date_part stored procs
Next
From: Bruno Wolff III
Date:
Subject: Re: order of results