Re: [GENERAL] SELECT'ing a function call

Command: create rule Description: define a new rule Syntax: CREATE RULE rule_name AS ON { SELECT | UPDATE | DELETE | INSERT } TO object [WHERE qual] DO [INSTEAD] [action|NOTHING|[actions]]; HTH Omid >From: "Jared H. Hudson" <[EMAIL PROTECTED]> >To: <[EMAIL PROTE

Re: Re: [GENERAL] index on a box

select * from pg_users; >From: ÀîÁ¢Ð <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Tom Lane <[EMAIL PROTECTED]>, Dustin Sallings <[EMAIL PROTECTED]> >CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> >Subject: Re: Re: [GENERAL] index on a box >Date: Sun, 08 Jul 2001 21:02:32 +0800 > >Tom Lane

[GENERAL] chr() in 7.0.3 !

hi all, I have pg 7.0.3 installed. I can use ascii() to get the ascii code of a character but I can not use chr() to reverse the function... is it a matter of the pg version I have? If so, is there any other way to get the text from the ascii number? TIA Omid Omoomi

Re: [GENERAL] OT: Design Books

Hi, The one I recommend is: Introduction to System Analysis and Design by Igor Hawryszkiewycz ISBN 013 896887 X Hope that helped Omid Omoomi >From: David Wheeler <[EMAIL PROTECTED]> >To: PostgreSQL-general <[EMAIL PROTECTED]> >Subject: [GENERAL] OT: Design Books >Date

Re: [GENERAL] Sort by foreign date column

and how about this: SELECT TO_CHAR(chdate, 'DD-MM-') FROM mytable ORDER BY chdate::date; >From: Mike Mascari <[EMAIL PROTECTED]> >To: "Andrey Y. Mosienko" <[EMAIL PROTECTED]> >CC: Stephan Szabo <[EMAIL PROTECTED]>, Postgres ><[EMAIL PROTECTED]> >Subject: Re: [GENERAL] Sort by foreign dat

Re: [GENERAL] Couple of design questions

howing it in an HTML form ) and then make a seperate update (using HTML input).At this case you will still have the risk of update error( if user B had made simultanious updates ), but still seems safer. Regards Omid Omoomi __

Re: [GENERAL] when are indexes used?

hi, I just wait afew days to see whether some one ( with more info about this issue in pg ) reply. but ... so here is my word : >From: InfraRED <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [GENERAL] when are indexes used? >Date: Sun, 19 Sep 1999 17:29:57 +0200 (CEST) > > >I noticed that

Re: [GENERAL] PSQL Function() help....

Hello, Sure you can use arrays as returned results in your function. regards. Omid Omoomi >From: Peter Eisentraut <[EMAIL PROTECTED]> >To: Dale Anderson <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: [GENERAL] PSQL Function() help >Date: Wed, 12 Ja

Re: [GENERAL] ORDER BY problems

hi, As far as I understand,tracking_num is primary key and uniqe! So when you sort the date by a uniqe field their would be no place for other fields to be sort on! May be you are going to sort the data some other way. so I think your query is doing well. Omid Omoomi >From: David Shrewsb

Re: [GENERAL] RestrictionClauseSelectivity

hi,put it in quotes: delete from aktuelles where index='9'; better not using some predefined key words like "index" as field names. >From: Ingo Assenmacher <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [GENERAL] RestrictionClauseSelectivity >Date: Wed, 23 Feb 2000 12:55:43 +0100 > >Hi All!

Re: [GENERAL] Nested tables

>Table ACL: >Attribute |Type | Modifier >---+-+ > uniqid| varchar(12) | not null > date_created | timestamp | not null > date_modified | timestamp | not null > read | boolean | not null default

Re: [GENERAL] How to retrieve table definition in SQL

Hi, There are some system tables in any pg database which contain information about table/field names/types and descriptions. use -e with psql command, and look at the sql code when running /d commands. regards. Omid Omoomi >From: Stan Jacobs <[EMAIL PROTECTED]> >To: [EMA