Re: [SQL] Arrays

2000-12-31 Thread Oleg Bartunov
Wait some time. We have something you need - we implement RD-tree using GiST interface. Unfortunately, GiST was very poorly tested and supported, so we have to understand, fix and rewrite some part of code. There are still some problems but we hope to get working code in January. Oleg On

[SQL] Arrays

2000-12-31 Thread Albert REINER
Saluton, I somehow get the impressions that support for arrays is not a high priority with PostgreSQL, even though I think it would be very handy. On the other hand, the system itself uses arrays e.g. for user groups, so I guess there should be readily available functions/operators for dealing wi

Re: [SQL] Unable to identify an ordering operator

2000-12-31 Thread Tom Lane
Ferruccio Zamuner <[EMAIL PROTECTED]> writes: > select persons.name,firm.name,persons.tel >from persons,work,firm >where (persons.table_owner=0) and > (work.id_firm=firm.id and work.id_person=persons.id) > union >select persons.name,firm.name,persons.t

[SQL] Unable to identify an ordering operator

2000-12-31 Thread Ferruccio Zamuner
Hello, select persons.name,firm.name,persons.tel from persons,work,firm where (persons.table_owner=0) and (work.id_firm=firm.id and work.id_person=persons.id) union select persons.name,firm.name,persons.tel from persons,work,firm wh

Re: [SQL] Rules

2000-12-31 Thread Peter Eisentraut
Peeter Smitt writes: > CREATE RULE update_rule AS ON UPDATE TO table DO INSTEAD > SELECT fun1(new); > > Thing is that backend gives this error. > ERROR: parser: parse error at or near ")" Try double quoting "new", since it's a reserved word. -- Peter Eisentraut [EMAIL PROTECTED]

[SQL] Rules

2000-12-31 Thread Peeter Smitt
Hi   I'm trying to make updateable view useing rules.   CREATE RULE update_rule AS ON UPDATE TO table DO INSTEAD  SELECT fun1(new);   Thing is that backend gives this error.   ERROR:  parser: parse error at or near ")"   What i'm doing wrong? Are there any other ways to make updatebale mul