Re: [SQL] recursive SQL and with clause

2006-11-15 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (chrisj) belched out: > I was just wondering when we could reasonably expect recursive SQL to be > added to Postgres? > > I saw some posts from 2004 that made it sound like it was imminent, > but I guess something went wrong? I believe t

Re: [SQL] Aggregate function to build 2-d array

2006-11-15 Thread chrisj
Hi Steven, I believe I saw something about a fix to array_append in the release notes for V8.2. Not sure if this helps. Steven Murdoch-2 wrote: > > I would like to aggregate several rows of a query, maintaining the > relative order. Is there an other way to achive the same result? I > have a

[SQL] Aggregate function to build 2-d array

2006-11-15 Thread Steven Murdoch
I would like to aggregate several rows of a query, maintaining the relative order. Is there an other way to achive the same result? I have an alternative construction, but I am not convinced it will work in all cases. For example, with the setup below: -- Concatenate elements of type t into arra

[SQL] recursive SQL and with clause

2006-11-15 Thread chrisj
I was just wondering when we could reasonably expect recursive SQL to be added to Postgres? I saw some posts from 2004 that made it sound like it was imminent, but I guess something went wrong? I believe the WITH clause is a pre-requisite for recursive SQL, however I do find the WITH clause also

Re: [HACKERS] [SQL] Case Preservation disregarding case

2006-11-15 Thread Jim Nasby
On Nov 14, 2006, at 2:42 PM, Simon Riggs wrote: On Thu, 2006-11-02 at 10:51 -0500, Tom Lane wrote: "Simon Riggs" <[EMAIL PROTECTED]> writes: We have namespaces to differentiate between two sources of object names, so anybody who creates a schema where MyColumn is not the same thing as myCol

Re: [SQL] sql problem with join

2006-11-15 Thread Luca Ferrari
On Wednesday 15 November 2006 16:20 your cat, walking on the keyboard, wrote: > May be you could show the results you are getting and then make up some > results that you would really like to get. I am not entirely clear what > you are trying to achieve. Lastly I found the solution, for the mome

Re: [SQL] sql problem with join

2006-11-15 Thread Richard Broersma Jr
> Hi all, > I've got a problem tryng to define a view with a few joins, I'll appreciate > if > someone could drive me in the definition of such query. > I've got a table roleSkill that contains a row for each skill belonging to a > defined role and with the desired competence level for such ski

[SQL] sql problem with join

2006-11-15 Thread Luca Ferrari
Hi all, I've got a problem tryng to define a view with a few joins, I'll appreciate if someone could drive me in the definition of such query. I've got a table roleSkill that contains a row for each skill belonging to a defined role and with the desired competence level for such skill in such r