Re: pl/pgsql

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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington