Re: Relative Search

[Chris Bannister <mockingbird@ihug.co.nz>]

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
> 
> michelle.konzack@michelle1:~ >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 
michelle.konzack@michelle1:~ $ echo 'SELECT p_id, first_name, last_name,
address FROM people 
WHERE last_name = 'hrussocszy' AND city = 'Chicago' AND country =
'USA';' > query_person.sql

michelle.konzack@michelle1:~ $ 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