[SQL] output query on many to many relationship into several columns

Dear list, assuming I have the following n:n relationship: t1: t2: intermediary table: t3 How can I create an output like this: -- View this message in context: http://postgresql.1045698.n5.nabble.com/output-query-on-many-to-many-relationship-into-several-columns-tp5733692.html Sen

Re: [SQL] SQL output

Quoting Simon Law <[EMAIL PROTECTED]>: > > CREATE TABLE tablename (field INTERVAL); > INSERT INTO tablename VALUES('3 weeks'); > SELECT field FROM tablename; > | 21 days | > > The output shows up in days or months but not weeks how do i make Internally, INTERVAL is stored as a 12byte tuple

[SQL] SQL output

CREATE TABLE tablename (field INTERVAL); INSERT INTO tablename VALUES('3 weeks'); SELECT field FROM tablename; _ | field | |--| | 21 days | || The output shows up in days or months but not weeks how do i make it output in weeks? Any help with this wi

Re: [SQL] output

Popeanga Marian wrote:       I am using libpg inside a plugin. For oracle conections i can read the server output with this package dbms_output.read_line (... ).    For pgsql is something similar for reading server output ?   Tom Lane wrote: Popeanga Marian <[EM

Re: [SQL] output

      I am using libpg inside a plugin. For oracle conections i can read the server output with this package dbms_output.read_line (... ).    For pgsql is something similar for reading server output ?   Tom Lane wrote: Popeanga Marian <[EMAIL PROTECTED]> writes: Now if i don't us

Re: [SQL] output

Popeanga Marian <[EMAIL PROTECTED]> writes: > Now if i don't use psql from where i can read the output ? If you're using libpq directly, you can install a notice processor hook routine to catch NOTICE messages. Otherwise they go to stderr. regards, tom lane -

Re: [SQL] output

On Thursday 02 October 2003 12:09, Popeanga Marian wrote: > > Inside a plpgsql block . > RAISE NOTICE ''Operation performed!''; > > Now if i don't use psql from where i can read the output ? Ah - I think you need to set CLIENT_MIN_MESSAGES accordingly and then you can check for a non-fatal

Re: [SQL] output

Richard Huxton wrote: On Thursday 02 October 2003 09:52, Popeanga Marian wrote: Hello all, I am interested on how can i put output data for debugging purposes. Any sample will be very good! Output what data when? To what? If you can describe your situa

Re: [SQL] output

On Thursday 02 October 2003 09:52, Popeanga Marian wrote: > Hello all, > > > I am interested on how can i put output data for debugging > purposes. Any sample will be very good! Output what data when? To what? If you can describe your situation, I'm sure we can come up with somethin

[SQL] output

Hello all, I am interested on how can i put output data for debugging purposes. Any sample will be very good! Thanks, /Marian ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] Output of function into a file

in 7.3 you will be able to return multiple rows with multiple columns. 7.3 stable is going to be out soon as it in beta 5 stage currently. regds mallah. On Saturday 09 November 2002 11:00, karthick v wrote: > Hi, > > I am writing a small function to manipulate records in multiple > tables. Si

Re: [SQL] Output of function into a file

> > I am writing a small function to manipulate records in multiple > tables. Since the function cannot return more than one value, I would > like to get all the outputs of the queries and append them into a text > file. > > Is there any way to do it inside the function. I came across many > pos

[SQL] Output of function into a file

Hi, I am writing a small function to manipulate records in multiple tables. Since the function cannot return more than one value, I would like to get all the outputs of the queries and append them into a text file. Is there any way to do it inside the function. I came across many postings which