[SQL] RE : [SQL] Convert text from UTF8 to ASCII

Hi Perhaps you should try to set your db client_encoding to UTF8. How do you know you have 'patiënt' instead of 'patiënt'? I mean i also deals with UTF8 databases and all i store is correctly stored. But i can't check it with command line psql as my shell is configured with iso-8859-1 charse

[SQL] unsubscribe

[SQL] unsubscribe ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] Trigger to identify which column(s) updated

n you find out the primary key of a record? Thanks, Jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[SQL] The problems about temporary tables in V7.3.2

just removes the access priority of the temporary tables. Jack ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] PHP LINK module (RPM format) for PostgreSQL V7.3

Hi, All Please advise where I can get the PHP LINK module (RPM format) for PostgreSQL V7.3. Thank you in advance! Jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[SQL] EXECUTE problem on schema

Hi, all postgreSQL v7.3.3 I found EXECUTE on pl/pgsql doesn't support schema. When I specify a table such as "public.tablename", it reported "not such a relation object". The only SQL statement I used is "update". Don't know wether other

Re: [SQL] the best way to get some records not in another table

Hi, According to the following report, I think using "except" would be the best way to do. Thank you! Jack EXPLAIN SELECT DISTINCT a.c1 FROM test_j2 a WHERE a.c1 NOT IN (SELECT DISTINCT b.c1 FROM test_j1 b); Unique (cost=54544.91..54547.41 rows=50 width=6)

Re: [SQL] About Create Type

Thanks Joe. Yes, that is exactly what I need. Jack ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] pl/pgsql how to return multiple values from a function

Thanks Rajesh. It 's very useful reference site. Jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the ma

Re: [SQL] pl/pgsql how to return multiple values from a function

Stephan , Both of two suggestion work. Thank you very much! Jack ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Inquiry From Form [pgsql]

Dear Sir/Madam, I would like to find out two things: 1)Do you have a function which is similar to Oracle\'s DECODE. 2) Can you extract day of week (Monday,etc) from yours date functions. Kind Regards, Jack Kiss ---(end of broadcast)--- TIP

[SQL] window version of psql of postgreSQL v7.3.1

Hi, all Where can I get a window version of psql of postgreSQL v7.3.1? Thank you very much! Jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [SQL] quastions about primary key

I try use uique instead of primary key. And it works, it allows null values. Is there any other difference between primary key and unique? Jack - Original Message - From: "Stephan Szabo" <[EMAIL PROTECTED]> To: "jack" <[EMAIL PROTECTED]> Cc: <[EMAIL PRO

[SQL] quastions about primary key

Is that possible to have a two columns primary key on a table with null value on second column? Jack ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [SQL] A problem about alter table

But on postgreSQL 7.2 reference manual, there is a statement for alter table such as, ALTER TABLE [ ONLY ] table [ * ] ALTER [ COLUMN ] column { SET | DROP } NOT NULL Do you mean this one hasn't been implemented? Jack - Original Message - From: "Tomasz Myrta" <[EM

[SQL] A problem about alter table

Hi, all I'm using postgreSQL 7.2.3. The following statement always cuases a parser error, "parse error at or near NOT". Please adivse, thank you in advance. ALTER TABLE _acct_group1 ALTER groupkey SET NOT NULL; Jack ---(e

[SQL] is numeric relational operator problem fixed in v7.3

Does the following now works in postgreSQL v7.3? Select * from a_table where num1 >10; *** type of num1 is NUMERIC (12,2) Jack ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "un

[SQL] numeric problems

anyone has done somethings on this problems? Or should I change NUMERIC type to FLOAT type? Please advise, thank you in advance. Jack ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] time limit of a database connection

I use a window client to conncet to a postgreSQL server with windows ODBC. It seems if I haven't done anything on the connection for hours, the connection will be dropped. Is that possible to set the time limit of a connection? Thank you in advance! Jack ---(e

Re: [SQL] the best way to get the topest 3 record in every group

Dima My question is that I want to produce ALL the lastest 3 records for EACH itemNo and supplier. Jack - Original Message - From: "dima" <[EMAIL PROTECTED]> To: "jack" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 09, 2002 4:34

[SQL] the best way to get the topest 3 record in every group

Hi, There is a table like : << itemNo supplier purchaseDate Price Qty << Please provide an idea if I want to get the latest 3 puchase records for each item and supplier. Thank you in advance. jack ---(end of broadcast)--- TIP 4: Do

[SQL]

s before I re-run the same SQL procedure in the same session? Jack ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[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] array variables in pl/pgsql

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 2: you can get off all lists at once with the

[SQL] transaction isolation question

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)--- T

[SQL] execute client application from PL/pgSql

Is that possible to execute a client application from server site by PL/Pgsql, such as pg_dump? Because my client sites are running Windows OS, or is there any Windows version of all Client Applications come from PostGreSQL V7.1? Jack ---(end of broadcast

[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 4: Don't 'kill -9' the postmaster

[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 b

Re: [SQL] Re: psql win32 version

Hi, Christopher Thank you for your help, but the URL http://www.zeos.dn.ua/download/ipgsql-1.6.2.zip is a broken link. Would you please check again. Thank you very much. Jack - Original Message - From: "Christopher Sawtell" <[EMAIL PROTECTED]> Newsgroups: comp.database

RE: [SQL] really need help

Hi, I would like to stop spending my work day deleting these messages. Is there anybody out there responsible for this? Make it stop! Now! Thanks > -Original Message- > From: Jie Liang [SMTP:[EMAIL PROTECTED]] > Sent: Friday, November 03, 2000 1:35 PM > To: [EMAIL PROTECTED]; [EMAIL P

[SQL] unsubscribe

unsubscribe application/ms-tnef

RE: [SQL]

Can I be removed from this mailing list? > -Original Message- > From: Yury Don [SMTP:[EMAIL PROTECTED]] > Sent: Monday, October 30, 2000 6:55 AM > To: [EMAIL PROTECTED] > Subject: Re: [SQL] > > Hello Lengyel, > > Once, Monday, October 30, 2000, 5:36:23 PM, you wrote: > > LF> Hel

[SQL] error 3122 in ACCESS -

ewFieldName: (1/[FieldName])*([FieldCreatedbyanEarlierExpressioninQuery]) }. 1st - What is a transform statement? 2nd- What is an aggregate function? 3rd - Would I need to change anything is SQL... and what? 4th- Why wouldn't the same expression work with a different field? Jack Schlobohm