Re: [SQL] cast

2005-10-18 Thread Dan Feiveson
I believe int8(n.udf4) will do the trick for you. - Original Message - From: "Judith Altamirano Figueroa" <[EMAIL PROTECTED]> To: Sent: Friday, October 14, 2005 12:08 PM Subject: [SQL] cast > Hello I have a query that ran in 7.0.2, but in 8.0.1 does not, the query > is the next: > >

Re: [SQL] tsearch2

2005-04-22 Thread Dan Feiveson
t tsearch2 -- do you know of any workarounds? Thanks for all your help Oleg, Dan - Original Message - From: "Oleg Bartunov" To: "Dan Feiveson" <[EMAIL PROTECTED]> Sent: Monday, April 18, 2005 10:13 PM Subject: Re: [SQL] tsearch2 > On Mon, 18 Apr 2005, Dan

[SQL] tsearch2

2005-04-18 Thread Dan Feiveson
r settings? --  We set  the locale of C on our current configuration to allow LIKE searches to use indexes - will this be affected?  Also what grants do we need to run to get a non super user working with tsearch2?   Thanks again for all your help,   Dan   Dan Feiveson DataJoe LLC    

Re: [SQL] Query runs very slowly in Postgres, but very fast in other DBMS

2005-04-12 Thread Dan Feiveson
You might also try: SELECT dokumnr FROM rid WHERE NOT EXISTS ( SELECT 'd' FROM dok WHERE dok.dokumnr = rid.dokumnr ); Dan Feiveson DataJoe LLC - Original Message - From: "Krasimir Dimitrov" <[EMAIL PROTECTED]> To: "Andrus Moor" <[EMAIL P

[SQL] OpenFTS

2005-04-11 Thread Dan Feiveson
respond,   Dan   Dan Feiveson Broomfield, Colorado