Re: [SQL] update syntax error?

2000-08-21 Thread mikeo
query should have a comma instead of the word and... HTH mikeo At 04:27 PM 8/20/00 -0300, The Hermit Hacker wrote: > >UPDATE SET field1=,field2= > >On Tue, 15 Aug 2000, k.c. hemelstrand wrote: > >> Can anybody help with why I am receiving the error below? >> >>

Re: [SQL] Re: Simple search question

2000-06-20 Thread mikeo
do select setval('seqname',#); At 01:17 PM 6/15/00 -0500, John McKown wrote: > >Alex wrote in message <[EMAIL PROTECTED]>... >>Hi, >> >>> I had the same problem but was using Java, not PHP (I guess that >>> whatever I can do in JDBC, you can do in PHP ;-)). >>> >>> SELECT last_value FROM ; >>

Re: [SQL] oracle rownum equivalent?

2000-06-07 Thread mikeo
thing "on the fly" or for what ifs. what i'm also interested in is how to find reference to these type of pseudo-columns, even just the names of them, if they're listed somewhere. thanks again, mikeo At 08:29 AM 6/7/00 -0500, Ed Loehr wrote: >mikeo wrote: >

[SQL] oracle rownum equivalent?

2000-06-07 Thread mikeo
is there an equivalent to rownum in oracle? also, where can one find reference to "hidden columns" such as OID or, as in oracle, rownum? thanks, mikeo

[SQL] short query becomes long

2000-06-01 Thread mikeo
query is doing an index scan. mikeo

[SQL] TOP SESSIONS?

2000-05-31 Thread mikeo
me the same or similar information? TIA, mikeo

Re: [GENERAL] Re: [SQL] remove line type?

2000-05-30 Thread mikeo
thanks much. that now works! :) At 01:41 PM 5/30/00 -0400, Tom Lane wrote: >mikeo <[EMAIL PROTECTED]> writes: >>>> we've run into a problem after having deleted the line type. >>>> when we attempt to query a table by column which is defined as float8 >

Re: [SQL] remove line type?

2000-05-30 Thread mikeo
for your perusal... >From: Bruce Momjian <[EMAIL PROTECTED]> >Subject: Re: [SQL] remove line type? >To: mikeo <[EMAIL PROTECTED]> >Date: Tue, 30 May 2000 10:48:02 -0400 (EDT) > >That is very strange. I would send it to the mailing lists. > >> hi bru