Re: [SQL] Name the Parameters

On Saturday 06 September 2003 06:42, Kumar wrote: > Dear Gurus, > > Is it possible to name the IN parameters of the PLpgSQL Functions. Because > naming the parameter will ease coding. See the following function for > insert, having 10 parameters as a input. No, though there is an item on the TODO

Re: [SQL] recursive sql

Good day On Friday 05 September 2003 21:41, you wrote: > can anyone recommend a good reference source for doing recursive sql on > postgresql? i want to do something similar to a BOM expansion. (i.e. i need > to traverse a self-referencing table that stores a tree structure and > answer a question

[SQL] Name the Parameters

Dear Gurus,   Is it possible to name the IN parameters of the PLpgSQL Functions. Because naming the parameter will ease coding. See the following function for insert, having 10 parameters as a input.   = CREATE

[SQL] recursive sql

can anyone recommend a good reference source for doing recursive sql on postgresql? i want to do something similar to a BOM expansion. (i.e. i need to traverse a self-referencing table that stores a tree structure and answer a question like "Get me A and all of A's descendents") Regards, Floyd S

Re: [SQL] Porting from Oracl to Postgres

--- Rod Taylor <[EMAIL PROTECTED]> wrote: > On Fri, 2003-09-05 at 00:24, Jomon Skariah wrote: > > > > Hi, > > > > Thanks for your replys. > > > > We are facing another problem now. > > > > we need to find an alternative for Oracle's > ADD_MONTHS in PostGres.. > > Guessing based on the name th

Re: [SQL] Porting from Oracl to Postgres

On Friday 05 September 2003 05:24, Jomon Skariah wrote: > Hi, > > Thanks for your replys. > > We are facing another problem now. > > we need to find an alternative for Oracle's ADD_MONTHS in PostGres.. SELECT now() + '1 hour'::interval; SELECT now() + '2 days'::interval; SELECT now() + '3 months':

Re: [SQL] Porting from Oracl to Postgres

On Fri, 2003-09-05 at 00:24, Jomon Skariah wrote: > > Hi, > > Thanks for your replys. > > We are facing another problem now. > > we need to find an alternative for Oracle's ADD_MONTHS in PostGres.. Guessing based on the name that it adds a quantity of months to a timestamp. How about an SQL I

Re: [SQL] Help me

Very thanks, George! - Original Message - From: George Weaver To: Yaroslav Ulyanov ; [EMAIL PROTECTED] Sent: Friday, September 05, 2003 12:48 AM Subject: Re: [SQL] Help me Hi Yaroslav,   You must set the language as:     LANGUAGE 'plpgsql';   Regar

[SQL] Transactions ID

Hello, Michael.   You may prompt me, what get the identifier to transactions?   Best regards,Yaroslav Ulyanov[EMAIL PROTECTED]

[SQL] Porting from Oracl to Postgres

Hi, Thanks for your replys. We are facing another problem now. we need to find an alternative for Oracle's ADD_MONTHS in PostGres.. Regards Jomon -Original Message- From: Rod Taylor [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 1:20 AM To: Jomon Skariah Cc: [EMAIL

Re: [SQL] Fw: Transactions ID

On Friday 05 September 2003 08:10, Yaroslav Ulyanov wrote: > Hello. > > You may prompt me, what get the identifier to transactions? Not entirely sure what you're after, but does chapter 2.2 of the manuals - "System Columns" help you? -- Richard Huxton Archonet Ltd -

Re: [SQL] Change column data type

On Tuesday 02 September 2003 10:50, Senthil Kumar S wrote: > Dear Friends, > > Using Postgres 7.3.4 over the linux server 7.3. > > Is it possible to alter/change the data type of a existing table's column, > with out dropping and recreating a column of same name. > > Thanks for ur knowledge sharing

[SQL] Fw: Transactions ID

  Hello.   You may prompt me, what get the identifier to transactions?   Best regards,Yaroslav Ulyanov[EMAIL PROTECTED]