into pg_options to see exactly why query is being executed.
Ken Kachnowich wrote:
> Whoops, sorry. I did not know the -04 was the time zone and thought
> it was causing my problem.
> My problem still exists, so I may be doing something else wrong.
> Has anyone done something like this and does it work?
> - Create a Timestamp with the curret date/time in it
> - Insert it into a datetime field in table A
> - Insert it into a datetime field in table B
> - select the datetime field from table A into a Timestamp variable
> - Use this Timestamp variable to select the record from table B
> I get no records found when I do this.
Increase signal to noise ratio. http://www.targabot.com
In response to
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2000-10-24 01:57:47|
|Subject: JDBC now needs updates for large objects|
|Previous:||From: Sandro Dentella||Date: 2000-10-23 22:16:04|
|Subject: Again libpgtcl for Win9* & tcl 8.3|