On Mon, 23 Apr 2001, Juan wrote:
> does anyone know where i found documentation about pl/pgsql ?
Documentation is in the Developer's Manual, at www.postgresql.org.
> i have a variable typed date and i need to get day month and year, how can i
> do that?
> e.g:
>
> function test(date)
> day = day($1);
> month = month ($1);
> year = year($1);
You don't need pl/pgsql for this. There are features built-in to
PG for these:
http://postgresql.readysetnet.com/devel-corner/docs/user/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington