Thread

1. RE: backend corruption

   Mikheev, Vadim <vmikheev@sectorbase.com> — 2001-01-08T17:19:30Z

   > I think that under 7.1, pg_log is not so critical anymore, but I'm not
   > sure.  Vadim, any comment?
   
   Still critical till we implement UNDO and true changes rollback on
   transaction abort.
   
   Vadim
   
   

2. Delete query

   Sandeep Joshi <sjoshi@zambeel.com> — 2001-01-10T20:17:46Z

   >
   
   What is wrong with following queries?
   
   Query1:
   delete from zuser where userid = 1 and user_setid = 1;
   
   ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
   'int4'
           You will have to retype this query using an explicit cast
   
   Query2:
   delete from zuser where userid = '1'::int4 and user_setid = '1'::int4;
   
   ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
   'int4'
           You will have to retype this query using an explicit cast
   
   Query3:
   delete from zuser where userid = '1'::integer and user_setid =
   '1'::integer;
   
   ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
   'int4'
           You will have to retype this query using an explicit cast
   
   
   thanks,
   sandeep
   
   

3. Re: Delete query

   Sandeep Joshi <sjoshi@zambeel.com> — 2001-01-10T21:39:34Z

   Sorry, my mistake.
   
   
   Sandeep
   
   
   > >
   >
   > What is wrong with following queries?
   >
   > Query1:
   > delete from zuser where userid = 1 and user_setid = 1;
   >
   > ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
   > 'int4'
   >         You will have to retype this query using an explicit cast
   >
   > Query2:
   > delete from zuser where userid = '1'::int4 and user_setid = '1'::int4;
   >
   > ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
   > 'int4'
   >         You will have to retype this query using an explicit cast
   >
   > Query3:
   > delete from zuser where userid = '1'::integer and user_setid =
   > '1'::integer;
   >
   > ERROR:   ERROR:  Unable to identify an operator '&&' for types 'int4' and
   > 'int4'
   >         You will have to retype this query using an explicit cast
   >
   > thanks,
   > sandeep