Skip site navigation (1) Skip section navigation (2)

Re: Bug #603: time() problems with PostgreSQL 7.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: suga(at)netbsd(dot)com(dot)br, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #603: time() problems with PostgreSQL 7.2
Date: 2002-02-26 15:28:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
> time('now') used to work but it doesn't work anymore in PostgreSQL 7.2.

TIME is a reserved word now, or at least more reserved than it used to
be, because we've added some SQL92 syntax that wasn't supported before.

	CAST('now' AS time)

In the INSERT command you showed originally, I don't actually believe
that you need any cast at all.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-02-26 15:35:06
Subject: Re: Bug #604: string join problem
Previous:From: pgsql-bugsDate: 2002-02-26 13:50:07
Subject: Bug #604: string join problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group