Re: [SQL] JDBC Performance

On Mon, 16 Oct 2000, Josh Berkus wrote: > Mr. May, > > For discussions of JDBC, please subscribe to the pgsql-interfaces > list. You will find many JDBC users on that list. > > -Josh Berkus > > P.S. PGSQL folks, is there any way we can clarify this

RE: [SQL] nested transactions

> > Just out of curiousity, does Postgres support nested transactions? > > I'd like to know too, and not just out of curiousity. I have > a use for that. Hopefully, savepoints will be available in 7.2 and give required functionality. Vadim

Re: [SQL] problem with select where like ']'

http://www.postgresql.org/users-lounge/index.html has most of them. Actually it's under General Info from the user's lounge. It was brought to my attention today that the list of archives was incomplete so I'll be adding to it and adding another one (developer and user). Don't get too attache

Re: [SQL] problem with select where like ']'

> > http://www.postgresql.org/users-lounge/index.html has most of them. > Actually it's under General Info from the user's lounge. > > It was brought to my attention today that the list of archives was > incomplete so I'll be adding to it and adding another one (developer > and user). Don't g

Re: [SQL] problem with select where like ']'

The only way I can find is to do a search on something, and select to search in mailing lists. Then after the search returns click on a link, and trucate the url to http://www.postgresql.org/mhonarc/ Bruce Momjian wrote: > > The fact is, I can't figure out how to get there without the URL. > >

Re: [SQL] problem with select where like ']'

The fact is, I can't figure out how to get there without the URL. > Joseph Shraibman <[EMAIL PROTECTED]> writes: > > WHAT mailing list archives? > > They aren't linked to anywhere on www.postgresql.org that I can find. > > Hmm. My bookmark is > > http://www.postgresql.org/lists/mailing-list.h

Re: [SQL] problem with select where like ']'

Joseph Shraibman <[EMAIL PROTECTED]> writes: > WHAT mailing list archives? > They aren't linked to anywhere on www.postgresql.org that I can find. Hmm. My bookmark is http://www.postgresql.org/lists/mailing-list.html Dunno how to get there from the site toplevel... reg

Re: [SQL] problem with select where like ']'

Tom Lane wrote: > > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > but i'm just wondering why like ']' doesn't work. > > What LOCALE setting are you running the postmaster in? > > ']' is not a special character as far as LIKE is concerned, but > I suspect you may be seeing another va

Re: [SQL] nested transactions

Bernie Huang writes: > Just out of curiousity, does Postgres support nested transactions? I'd like to know too, and not just out of curiousity. I have a use for that. -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI

Re: [SQL] nested transactions

Net yet. [ Charset ISO-8859-15 unsupported, converting... ] > Hi, > > Just out of curiousity, does Postgres support nested transactions? > > > - Bernie Content-Description: Card for Bernie Huang [ Attachment, skipping... ] -- Bruce Momjian| http://candle.pha.pa.

Re: [SQL] problem with select where like ']'

> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > but i'm just wondering why like ']' doesn't work. > > What LOCALE setting are you running the postmaster in? > > ']' is not a special character as far as LIKE is concerned, but > I suspect you may be seeing another variant of the problems

Re: [SQL] problem with select where like ']'

hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > but i'm just wondering why like ']' doesn't work. What LOCALE setting are you running the postmaster in? ']' is not a special character as far as LIKE is concerned, but I suspect you may be seeing another variant of the problems that LIKE i

[SQL] problem with select where like ']'

hi, i have a table (view actually) which contains field "article_name" which is written like: [AGD]|[Kuchenki Mikrofalowe]|[Samsung AKMS1] i.e. some string within "[]" delimited by "|" i want to select all record that have "[AGD]|[" in front of them so i tried select * from my_view where article_

[SQL] Big Sub-select statement

Hi, Let's say if I have a log table with (log_id, emp_id, book_id, author_id), and there are foreign tables related to each id except the log_id. Is it possible to write up a big sub-select statement to retrieve all possible info? eg1; (big sub_select) select ltb.log_id, ltb.emp_id, ltb.book_id

[SQL] nested transactions

Hi, Just out of curiousity, does Postgres support nested transactions? - Bernie begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada version

Re: [SQL] Variable-length Types

> It takes a string and returns something that looks like Varchar(22); > If someone types in 10 digits, it returns output like (###) ###- > If a user enters 7 digits, it picks a default area code and returns > (415) ###-, > and if they type more than 10 digits or enter any digits after an

Re: [SQL] Last serial number inserted

Eduardo, Use the curval(serial) function. For more information, look in the online docs under the name of that function. nextval(), curval() are wonderful things! -Josh Berkus -- __AGLIO DATABASE SOLUTIONS___

[SQL] Last serial number inserted

How can I get the last id ( serial number ) inserted. My C code is : res = PQexec(conn,"insert into table1 (field1) values ('value1')"); table1: id SERIAL, field1 VARCHAR(10) Thanks Eduardo K