[SQL] nesting XmlAgg

2008-07-02 Thread Isaac Dover
hi all, i'm coming from the MS SQLXML world and attempting to learn SQL/XML, but i'm having some trouble... my first project, which i thought would be simple, is to create an xml model using the information schema views... i'm simply trying to build a document such as:

Re: [SQL] Need a sample Postgre SQL script

2008-07-02 Thread Dhanushka Samarakoon
Worked perfectly. Thanks Richard. On Tue, Jul 1, 2008 at 10:17 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Dhanushka Samarakoon wrote: > >> Thanks for the reply. >> But one problem I have is I need to loop through all the rows in the table >> and in each iteration I need to fetch the value of

Re: [SQL] column default dependant on another columns value

2008-07-02 Thread Fernando Hevia
> -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] En nombre de Tom Lane > Enviado el: Martes, 01 de Julio de 2008 19:24 > Para: Fernando Hevia > CC: 'Richard Broersma'; pgsql-sql@postgresql.org > Asunto: Re: [SQL] column default dependant on another columns value