Re: [SQL] Error message: standard SQL or PostgreQSL?

Huub <[EMAIL PROTECTED]> writes: > When I copied a function call into an SQL-statement and executed it, I > got the message 'Aggregate function calls may not be nested'. Does that > mean this is the case in standard SQL or is this specifically PostgreSQL? It's in the standard: SQL92 (which calls

[SQL] Proposal of hierarchical queries, a la Oracle

Hi there! I want to propose the patch for adding the hierarchical queries posibility. It allows to construct queries a la Oracle for ex: SELECT a,b FROM t CONNECT BY a PRIOR b START WITH cond; I've seen this type of queries often made by adding a new type, which stores position of row in the tre

[SQL] Updating a table column with ref integrity

I need to to change the type of a table column. The problem is that this table has a ref integrity constarint set up with another table. Does anyone know how I can do this easily without breaking any constraints. thanks ---(end of broadcast)---

[SQL] Does Postgres replace \\ with \ in an update query

Hi All I am doing a normal SQL update against postgres. Seems to be replacing \\ with \ when it gets saved in the database. eg. \\machine\folder is being replaced with \machine Any ideas? Vaughn ---(end of broadcast)--- TIP 2: you can get off al

Re: [SQL] Error message: standard SQL or PostgreQSL?

On Fri, 15 Nov 2002, Huub wrote: > Hi, > > When I copied a function call into an SQL-statement and executed it, I > got the message 'Aggregate function calls may not be nested'. Does that > mean this is the case in standard SQL or is this specifically PostgreSQL? Umm, both sort of. It's an entr

Re: [SQL] Proposal of hierarchical queries, a la Oracle

Evgen, you'd need to post your message and patch to hackers mailing list. btw, did you try contrib/ltree module ? regards, Oleg On Fri, 15 Nov 2002, Evgen Potemkin wrote: > > Hi there! > > I want to propose the patch for adding the hierarchical queries posibility. > It allows

Re: [SQL] Updating a table column with ref integrity

Teknokrat, > I need to to change the type of a table column. The problem is that > this > table has a ref integrity constarint set up with another table. Does > > anyone know how I can do this easily without breaking any > constraints. Easily? No. In sum: dump your database to file. Backup

Re: [SQL] Does Postgres replace \\ with \ in an update query

On Friday 15 Nov 2002 7:23 am, Vaughn Cleminson wrote: > Hi All > > I am doing a normal SQL update against postgres. > Seems to be replacing \\ with \ when it gets saved in the database. eg. > \\machine\folder is being replaced with \machine > > Any ideas? The backslash (\) character is used to es

[SQL] how can I improve the speed of this query

Hi-- I have this rather long complex query that takes really long to complete (please see below). It seems like I ought to improve the speed somehow. I don't understand, for example, what the query planner is doing when it says "Hash" and why this appears to take so long. And since I have a key fo