7.3RC2 does not have datetime() function?

From: Jean-Christian Imbeault <totsubo2001(at)netscape(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 7.3RC2 does not have datetime() function?
Date: 2002-11-27 08:48:31
Message-ID: 3DE486DF.9050801@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Don't know if this is a bug or not but ... this query worked under 7.2.1
but doesn't under 7.3RC2. datetime was a built-in function ...

$ psql JC -c "select to_char(datetime(upload_time),'YYYY-MM-DD') as
utime from products where id='989000627108' "
ERROR: Function datetime(timestamp without time zone) does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts

JC

Browse pgsql-bugs by date

  From Date Subject
Next Message Jean-Christian Imbeault 2002-11-27 10:01:39 .3RC2 does not have datetime() function?
Previous Message Neil Conway 2002-11-27 03:27:40 Re: A little bug in postgreSQL