Re: [SQL] Fetching a single column from a record returning function

2004-01-21 Thread Kumar
Yes it worked. Thanks - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Kumar" <[EMAIL PROTECTED]> Cc: "psql" <[EMAIL PROTECTED]> Sent: Tuesday, January 20, 2004 9:28 PM Subject: Re: [SQL] Fetching a single column from a record returning function > "Kumar" <[EMAIL PROTECTED

[SQL] cygwin warnings in the log file

2004-01-21 Thread Terence Kearns
I get these LOG: shmdt(0xf8) failed: Invalid argument anyone know what's up with that? ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[SQL] time series data

2004-01-21 Thread azwa
Hi,     i want to create time table  & the structure as below :                 Column  Type  Modifiers time_key yr_id month_id month_desc day_id  integer  integer  integer  text  integer  not null default nextval('time_seq'::text) Example of data in time table: Time_key  yr_id   mon

Re: [SQL] time series data

2004-01-21 Thread Tomasz Myrta
Dnia 2004-01-21 09:53, Użytkownik [EMAIL PROTECTED] napisał: time_key integer not null default nextval('time_seq'::text) > Example of data in time table: > Time_keyyr_idmonth_idmonth_desc day_id > 1999 1 Jan 1 > 1999 1 Jan 2 > 2000

Re: [SQL] time series data

2004-01-21 Thread Tomasz Myrta
Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał: Use this integer sequence and interval datatype to get date result: your_date='1994-01-01'::date+'1 day'::integer * time_key ^^^ Sorry, use interval here. Regards, Tomasz Myrta -

[SQL] array_lower /array_prepend doubt

2004-01-21 Thread Rajesh Kumar Mallah
Greetings! can anyone explain why SELECT array_lower(array_prepend(0, ARRAY[1,2,3]), 1); returns 0 not 1 because tradein_clients=# SELECT array_prepend(0, ARRAY[1,2,3]); +---+ | array_prepend | +---+ | {0,1,2,3} | +---+ (1 row) and tradein_clients=# SE

Re: [SQL] array_lower /array_prepend doubt

2004-01-21 Thread Stephan Szabo
On Wed, 21 Jan 2004, Rajesh Kumar Mallah wrote: > can anyone explain why > SELECT array_lower(array_prepend(0, ARRAY[1,2,3]), 1); > returns 0 not 1 > > because > > tradein_clients=# SELECT array_prepend(0, ARRAY[1,2,3]); > +---+ > | array_prepend | > +---+ > | {0,1,2,3}

Re: [SQL] array_lower /array_prepend doubt

2004-01-21 Thread Tom Lane
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: > can anyone explain why > SELECT array_lower(array_prepend(0, ARRAY[1,2,3]), 1); > returns 0 not 1 Because array_prepend keeps the subscripts of the existing array elements the same. This was discussed during development of the code, but I don't s

Re: [SQL] array_lower /array_prepend doubt

2004-01-21 Thread Joe Conway
Tom Lane wrote: Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: can anyone explain why SELECT array_lower(array_prepend(0, ARRAY[1,2,3]), 1); returns 0 not 1 Because array_prepend keeps the subscripts of the existing array elements the same. This was discussed during development of the code, but I

Re: [SQL] array_lower /array_prepend doubt

2004-01-21 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Because array_prepend keeps the subscripts of the existing array >> elements the same. This was discussed during development of the >> code, but I don't see anything in the documentation that mentions it. > It could perhaps be added to t

Re: [SQL] array_lower /array_prepend doubt

2004-01-21 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > I'll put some thought into it, but note that it is hardly a new issue -- Of course; I suppose this bug goes back to Berkeley days. We just hadn't recognized it before (or at least I hadn't). regards, tom lane

Re: [SQL] array_lower /array_prepend doubt

2004-01-21 Thread Joe Conway
Tom Lane wrote: The other point about pg_dump failing to correctly restore arrays with nondefault lower bounds is a good one, though. We need to think about how to fix that. I'll put some thought into it, but note that it is hardly a new issue -- it's been possible to create an array with < 1 low

Re: [SQL] array_lower /array_prepend doubt

2004-01-21 Thread Joe Conway
Tom Lane wrote: Of course; I suppose this bug goes back to Berkeley days. We just hadn't recognized it before (or at least I hadn't). Neither had I. But the changes in 7.4 probably make it more likely people will bump into this as a problem. Without looking to confirm, I believe SQL99 defines an

Re: [SQL] array_lower /array_prepend doubt

2004-01-21 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > We may need another extension to the array literal syntax in > order to deal with this. I'll report back after I've had some time to > study it. There already is support in array_in for specification of the array dimensions (though it may be suffering bit

[SQL] Batch Updates problem

2004-01-21 Thread beyaRecords - The home Urban music
Hi, my first question is, is pg74jdbc3.2.jar the latest driver for postgresql? If so, does it support batch updates? I ask this because I am using Hibernate, or trying to should I say!, to do EJB stuff to postgresql and when I try to commit() data to a postgresql table i get the following error: '

[SQL] Batch Updates issue

2004-01-21 Thread beyaRecords - The home Urban music
Hi, my first question is, is pg74jdbc3.2.jar the latest driver for postgresql? If so, does it support batch updates? I ask this because I am using Hibernate, or trying to should I say!, to do EJB stuff to postgresql and when I try to commit() data to a postgresql table i get the following error: '