On Sun, Jan 22, 2006 at 05:35:44PM +0100, Michelle Konzack wrote: > Am 2006-01-06 15:54:38, schrieb Andrew Sackville-West: > > > try this > > > > find -L -atime+34675 /chicago -iname hrussocszy > > [EMAIL PROTECTED]:~ >psql world > world=# SELECT * FROM residents WHERE name ~* "hrussocszy", city ~* "chicago" > LIMIT 10;
(Is that valid SQL??) Have a look at the -f option to psql. i.e [EMAIL PROTECTED]:~ $ echo 'SELECT p_id, first_name, last_name, address FROM people WHERE last_name = 'hrussocszy' AND city = 'Chicago' AND country = 'USA';' > query_person.sql [EMAIL PROTECTED]:~ $ psql world -f query_person.sql p_id | first_name | last_name | address ------+------------+-----------+--------- (0 rows) SQL corrected. world db NOT NORMALISED!!! :-( -- Chris. ====== Reproduction if desired may be handled locally. -- rfc3 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
