Thread

1. SELECT Command? Messed again?

   Daniel W. Forsyth <forsyth@wchat.on.ca> — 1998-06-01T21:16:38Z

   Hi there, I'm currently using 6.3.
   
   When I issue the command SELECT * FROM client_database WHERE client ~~
   '%%' it displays nobody, when i use 6.1 it works fine, as %% or %%%%
   defaults to every entry? Does anyone know what is going on?
   
   PS: Please help, the companies client database is quite important :-).
   
   Thanks
   
   -- 
   Daniel W. Forsyth
   
   DATAFORGE
   PHONE: 905-632-9918  FAX: 905-632-1907
   
   

2. Re: [SQL] SELECT Command? Messed again?

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-06-01T21:37:31Z

   > 
   > Hi there, I'm currently using 6.3.
   > 
   > When I issue the command SELECT * FROM client_database WHERE client ~~
   > '%%' it displays nobody, when i use 6.1 it works fine, as %% or %%%%
   > defaults to every entry? Does anyone know what is going on?
   > 
   > PS: Please help, the companies client database is quite important :-).
   > 
   
   Actually, % is all that is needed.  %% is actually a single %, I think. 
   I had it wrong in earlier version, but it was fixed in 6.something.
   
   -- 
   Bruce Momjian                          |  830 Blythe Avenue
   maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
     +  If your life is a hard drive,     |  (610) 353-9879(w)
     +  Christ can be your backup.        |  (610) 853-3000(h)