Re: [SQL] Backend message type 0x50 arrived while idle

process lock before sending QA, and unlock when receiving AA. Hope it helps !! Thrasher Berman, Phil wrote: To all- I am using Postgres version 6.5.1 in a multithreaded program which is written in C. All inserts and updates into any tables are done within the child process, and there are

Re: [SQL] Date trunc in UTC

gsql'; I guess that it can be adapted for other time functions with ease, but I do not need them yet. Thanks to everybody involved, Thrasher Tom Lane wrote: Thrasher <[EMAIL PROTECTED]> writes: The biggest point that I see is that it would be nice to have some kind of function tha

Re: [SQL] Date trunc in UTC

The biggest point that I see is that it would be nice to have some kind of function that works with UTC values, regarding of which timezone the user has set. Let's say, something like SELECT UTC_DATE_TRUNC ('month', NOW ()); utc_date_trunc 2002-11-01 01:00:00+01

Re: [SQL] Date trunc in UTC

No I cannot use SET TIME ZONE. SET TIME ZONE will be set by any client backend. But what I want to get is that DATE_TRUNC('month', ) = DATE_TRUNC('month', ). Richard Huxton wrote: On Wednesday 20 Nov 2002 9:44 am, Thrasher wrote: Hi I do not know if it's an

[SQL] Date trunc in UTC

Hi I do not know if it's an error, but in this query =# select date_trunc ('month', now ()); date_trunc 2002-11-01 00:00:00+01 (1 row) I've got the truncated date dependant to my timezone. Instead, I would like to have as a result 2002-11-01 01:00:00+01 which

Re: [SQL] NOTICE: generated by sequence nextval()

Hi Just to explain you that I received this email and I am not an intended or authorized recipient. So, as you ask, I'm notifying you and deleting the mail from my computer. Thank you Michael Ansley (UK) wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I would hope that this is normal, a

Re: [SQL] Updating from select

Hi Manfred, Such a silly thing blocked me, and I was about to write a stored procedure. Thanks a lot !! BTW, does anyone knows about a RH7.2 or newer RPM of v7.3? Do I need any other tools not included in RH7.2 to compile it? Thrasher Manfred Koizar wrote: > On Wed, 02 Oct 2002 19:11

[SQL] Updating from select

hanks in advance Thrasher ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Unique constraint over null values

Thanks a lot for your prompt reply Thrasher Josh Berkus wrote: > Thrasher, > > >>where type can be 's' for 'single' and 'x' for extended, so s should >>mean that there is only the type and data1 field, and x means that all >>fields ar

[SQL] Unique constraint over null values

a1 field, and x means that all fields are set. How can I set a unique constraint like CHECK (type = 's' AND UNIQUE (type, data1)) OR (type = 'x' AND UNIQUE (type, data1, data2)) ? The documentation says that 2 NULL values are different, so no unique constraint