pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
help needed 4+ messages / 4 participants [nested] [flat]
* help needed @ 1999-06-16 17:26 Ravneet Mann <rsmann123@yahoo.com> 0 siblings, 0 replies; 4+ messages in thread From: Ravneet Mann @ 1999-06-16 17:26 UTC (permalink / raw) To: pgsql-sql Hi ! I am trying to test the Postgresql database on different networks. For this purpose I want to find out how much time does it take to execute each query. Can anyone tell me how to calculate the database retreival time for a query ? Any help will ne highly appriciated. Regards, Ravneet. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ^ permalink raw reply [nested|flat] 4+ messages in thread
* Help needed @ 2002-08-27 09:20 Mowat, Paul <Paul_Mowat@bmc.com> 0 siblings, 0 replies; 4+ messages in thread From: Mowat, Paul @ 2002-08-27 09:20 UTC (permalink / raw) To: pgsql-sql Dear postgresql, I am just starting to learn SQL. I have attached a script that allows me to create some tables and indexes. I have rows that are inserted into the tables. I need some help with creating multiple subqueries and table joins, (six or seven table joins). Can you help? Paul Mowat Software QA Engineer Enterprise Data Management --------------------------------------- BMCSoftware Abingdon UK Direct: +44 1235 827408 Fax: +44 1235 827430 Email: paul_mowat@bmc.com. www.bmc.com Attachments: BaseSetofObjects.sql (application/octet-stream, 10.4K) download ^ permalink raw reply [nested|flat] 4+ messages in thread
* Help needed @ 2005-11-30 09:18 NosyMan <nosyman@gmail.com> 0 siblings, 1 reply; 4+ messages in thread From: NosyMan @ 2005-11-30 09:18 UTC (permalink / raw) To: pgsql-sql Hi everyone, I have some kind of strange problem. I want to build general parametrized trigger for my database. The parameter sent to the trigger contains a column name that trigger should be check. CREATE OR REPLACE FUNCTION F_T_IU__check() RETURNS trigger AS $$ DECLARE vt VARCHAR; BEGIN ........................................................... vt:='constant_value_id'; RAISE EXCEPTION 'aaa=%', NEW.vt; ............................................................. The 'vt' variable contains the column name. In the above statement I want that NEW.vt to be interpreted as NEW.constant_value_id. It is possible to do this? Thanks, Nosy ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Help needed @ 2005-11-30 10:35 Richard Huxton <dev@archonet.com> parent: NosyMan <nosyman@gmail.com> 0 siblings, 0 replies; 4+ messages in thread From: Richard Huxton @ 2005-11-30 10:35 UTC (permalink / raw) To: NosyMan <nosyman@gmail.com>; +Cc: pgsql-sql NosyMan wrote: > Hi everyone, > > I have some kind of strange problem. I want to build general parametrized > trigger for my database. The parameter sent to the trigger contains a column > name that trigger should be check. > The 'vt' variable contains the column name. In the above statement I want that > NEW.vt to be interpreted as NEW.constant_value_id. It is possible to do this? Not in pl/pgsql - try one of the more interpreted languages - tcl/perl/python etc. Oh, and try not to reply to a previous message when starting a new thread - it can mess with threading in some mail packages. -- Richard Huxton Archonet Ltd ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-11-30 10:35 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-06-16 17:26 help needed Ravneet Mann <rsmann123@yahoo.com> 2002-08-27 09:20 Help needed Mowat, Paul <Paul_Mowat@bmc.com> 2005-11-30 09:18 Help needed NosyMan <nosyman@gmail.com> 2005-11-30 10:35 ` Re: Help needed Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox