[SQL] array variable in pl/pgsql

Hi all Is there any sample to show how to use array variable in PL/pgsql? How do I get an array from a table and do a loop to manipulate every element in that array? jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

[SQL] array variable in pl/pgsql

Hi all Is there any sample to show how to use array variable in PL/pgsql? How do I get an array from a table and do a loop to manipulate every element in that array? jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http:

[SQL] problem with date/time constants

Hi, server:PostgreSQl 7.1 why doesn't following statement work? "select now;" THANK YOU! JACK LIU ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[SQL] When using COPY

By using ... COPY [ BINARY ] table [ WITH OIDS ] FROM { 'filename' | stdin } [ [USING] DELIMITERS 'delimiter' ] [ WITH NULL AS 'null string' ] [BINARY]: If I use it instead of choosing a delimiter, is that safe for copied data and more quick to copy? [WITH OIDS] : If my application di

[SQL] question about PL/pgSQL function

With postgres 7.1 1. Function like example found on 24.4 Example in Programmer Guide CREATE FUNCTION xxx (EMP, integer) RETURNS boolean AS'.. (which EMP is a table ) How do I pass a record to this function in PL/PGSQL? I try this select into rec1 * from EMP where empNo =''

Re: [SQL] execute client application from PL/pgSql

Thank You Jeff, What is phpPgAdmin and where can get it? Jack - Original Message - From: "Jeff MacDonald" <[EMAIL PROTECTED]> To: "Jack" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, May 12, 2001 2:28 AM Subject: Re: [SQL] execute client application from PL/pgSql > you c

[SQL] Client Applications come with PostGreSQL V7.1

Is there any Windows version of all Client Applications come with PostGreSQL V7.1? Jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your mes

[SQL] Question about Committed Isolation

Regarding "Committed Isolation" on PostgreSql Ver 7.1 Users Guide, is that possible a "Dead Lock" happened when two concurrent transactions are waiting each other? And how to avoid or fix it? Jack ---(end of broadcast)--- TIP 5: Have you checked

[SQL] Re: [GENERAL] install pgSQL 7.1

No, I'm still at sea. Please help ! JACK - Original Message - From: "Justin Clift" <[EMAIL PROTECTED]> To: "datactrl" <[EMAIL PROTECTED]> Sent: Tuesday, April 10, 2001 3:18 AM Subject: Re: [GENERAL] install pgSQL 7.1 > Hi, > > Have pe

[SQL] About Raise Exception

According to user guide, both Raise Notice & Raise Exception will write message to database log. Which system table is the database log about? By the way what is the difference between Raise Notice & Raise Exception? Jack ---(end of broadcast)-

[SQL] how do I check if a temporary table exists?

How do I check if a temporary table exists? Searching pg_tables with a temporary table name we chose always fails. JACK ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAI

[SQL] SOME PL/PGSQL PROBLEMS

I found there are some problems with PL/pgSQL. 1) 'Drop Table' doesn't work at all 2) '--' comment causes parsing error 3) Execute doesn't work at all. It always causes parsing error! Some questions 1) Can I use variable in FROM clause for a table name? 2) Can I use variable in WHERE such as xxx

[SQL] drop table in PL/pgSQL

When I use "drop Table ..." in PL/pgSQL, it always causes an error as "ERROR copyObject: don't know how to copy 614" JACK ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [E

[SQL] database log

Since "raise exception" in pl/pgSQL will write error message to database log, how can I read database log. If I do "select * from pg_log;", it will show an error message as "pg_log can not be accessed by user". JACK ---(end of broadcast)--- TIP 3

Re: [SQL] Re: psql win32 version

s.postgresql.sql Sent: Thursday, March 15, 2001 1:19 PM Subject: Re: [SQL] Re: psql win32 version > This one worked a minute ago:- > > http://www.zeos.dn.ua/download/ipgsql-1.6.2.zip > > > On Thu, 15 Mar 2001 14:14, datactrl wrote: > > The URL shown below can not g

[SQL] how do I find which ...

I write some functions inPL/pgSQL. If I drop a function B , which is called by function A, and create function B again, then function A won't work unless I drop function A and re-create again. How about if there are lots functions call to function B, is there any way to search system table to find

[SQL] Some questions about PLpgSql

Hi, all By using 'PLpgsql', is that possible to 1) check if a specific table exists? 2) check if an INSERT/UPDATE/ DELETE has done successfully? Is there some more documents or samples for PLpgsql except USER GUIDE and PostgreSQL Introduction & concept? THANK YOU JACK ---

[SQL] Re: psql win32 version

The URL shown below can not get through. Would you please check again. Thank You JACK - Original Message - From: "Marc Cromme" <[EMAIL PROTECTED]> To: "'datactrl'" <[EMAIL PROTECTED]> Sent: Wednesday, March 14, 2001 6:58 PM Subject: RE: psq

[SQL] psql win32 version

Is there a win32 version for psql? JACK ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])