Re: [SQL] Multiple DB join

2006-08-18 Thread Sumeet
On 8/15/06, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > I previously thought of doing the full text search indexing thing...but i> had a intution that the full text search thing is for fields which have very> large strings...but in my case the  strings are not above 200 chars in No, it's for d

Re: [SQL] Multiple DB join

2006-08-18 Thread Andrew Sullivan
On Fri, Aug 18, 2006 at 11:07:24AM -0400, Sumeet wrote: > > Will the full text search indexing help me achive a good speed in searching > keywords??? I think this depends on how you use it. > can someone plz ellaborate a little about ways we can enforce bounded > searches?. I'm basically trying

[SQL] trigger needs to check in multiple tables.

2006-08-18 Thread Jacobo García
Hello.I'm running a simple query inside a function that is associated with a trigger:    SELECT tipo INTO tipocuenta FROM producto WHERE codigo_cuenta=NEW.codigo_destino ;I am getting this error when running the code on pgadmin IIIERROR:  NEW used in query that is not in a rule QUERY:  SELECT  tipo

Re: [SQL] trigger needs to check in multiple tables.

2006-08-18 Thread Michael Fuhr
On Fri, Aug 18, 2006 at 07:17:27PM +0200, Jacobo Garca wrote: > I'm running a simple query inside a function that is associated with a > trigger: > >SELECT tipo INTO tipocuenta FROM producto WHERE codigo_cuenta= > NEW.codigo_destino; > > I am getting this error when running the code on pgadmi