On Mon, Jan 23, 2006 at 06:24:43PM +0100, f g wrote:
> it seems a big montain just for that
Not really -- it's just that MySQL has a shortcut for a particular
special case and PostgreSQL has a more powerful generalized mechanism
(as does MySQL 5.0 with its "rudimentary triggers").
> plus had to do
> (shell) createlang -d [db] plpgsql
That's because PL/pgSQL isn't installed by default unless you've
created it in your template database.
> and replace $$ by simple quote
Dollar quotes are available in PostgreSQL 8.0 and later; if you're
running an earlier version then you'll have to use single quotes.
> and do you know why timestamp is only date instead of
> date+time ?
Timestamps contain both date and time. Can you show an example of
what you're doing to get only dates?
--
Michael Fuhr