[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

RE: [SQL] Order by email address by domain ?

here's an idea: if you would have all emails stored in the reverse order: moc.niamod@resu then all you would need is simple 'ORDER BY email'. Also, in this way, emails like [EMAIL PROTECTED] would be perfectly ordered. Is that a crazy thought? If not yet then: why not to add an

[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] Re: Informix-PostgreSQL database convertion

I think this isn't so difficult. Use unload to ... on Informix side ( from dbaccess ) and copy ... from ... om Postgres side. Sylte [EMAIL PROTECTED] ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: 9d8r7v$1to$[EMAIL PROTECTED]">news:9d8r7v$1to$[EMAIL PROTECTED]... Howto? Are there tools or is it just a

[SQL] Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Oracle ROWNUM = PSQL ???

Oracle has a ROWNUM pseudo column that works like this ... TESTselect callid, rownum from cs_calls where rownum 5; CALLID ROWNUM -- -- 7806 1 7807 2 7809 3 6443 4 4 rows selected. ... which can be quite handy.

[SQL] Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement

NOTE: I did a moderate search through the PgSQL mail list archives, but couldn't find an example of a question where both ORDER BY and aggregation were used. In all examples it was possible to use either one or the other with a possible subselect. [Keep reading...I discovered how to do this

[SQL] Re: Informix-PostgreSQL database convertion

It is convertion of the data, not the application... ---(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

[SQL] Informix-PostgreSQL database convertion

Howto? Are there tools or is it just a lot of hard work with a lot of PHP? Some examples or site-links will be appreciated :O) Thanks - Sylte ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Problem in Porting from Oracle to Postgres SQl

Hi! I am facing two problems in porting from oracle to Postgres SQL. 1> There is a code in Oracle like Type Tstate is table of number(9) index by binary_integer; . To define a runtime table, basically it works like a array, How can it be possible in Postgres SQL, I have tried create

[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

Re: [SQL] Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???

* Robert Beer [EMAIL PROTECTED] menulis: Oracle has a ROWNUM pseudo column that works like this ... TESTselect callid, rownum from cs_calls where rownum 5; CALLID ROWNUM -- -- 7806 1 7807 2 7809 3 6443

[SQL] Re: How to store gif or jpeg? Thanks!

src/interfaces/jdbc/example/ImageViewer.java Somewhere on the internet Please be more specific ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement

Okay, I found a workaround for PostgreSQL 7.0.3 for the specific query I was working on below, but I'd still like to know if an ORDER BY clause will ever be allowed with an aggregated SELECT statement, and whether it would generally be more efficient to use an ORDER BY in the situation described

[SQL] Is this possible?

I have a table that has a serial for primary key. Is it possible to get the new available primary key right after I insert a row of new entry? Thanks Wei ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???

Robert Beer [EMAIL PROTECTED] wrote: Oracle has a ROWNUM pseudo column that works like this ... TESTselect callid, rownum from cs_calls where rownum 5; Is there something like this in PSQL? SELECT callid FROM cs_calls LIMIT 4; HTH, Ray -- Give a man a fire, he's warm for a day. Set a man

[SQL] RE: Order by email address by domain ?

??? I don't think anyone suggested adding a new builtin function. Yes, your suggestion is good for an occasional use. Where this kind of functionality is likely to be needed on a continuing basis, my experience is that wrapping the code up in a custom function is easier and cleaner than writing

[SQL] Re: [HACKERS] Problems in porting from Oracle to Postgres

This is more appropriate for the pgsql-sql list, so im forwarding it that way. The hackers list is for other purposes. On Fri, May 11, 2001 at 12:24:25PM +0530, Amit wrote: 1 There is a code in Oracle like Type Tstate is table of number(9) index by binary_integer;

[SQL] create type and domains

I'm trying to simulate domains in PostgreSQL using the create type function, but I cannot find how the input and output functions for standard types are called. Is there anyone who can help me ? Thanks! --Valerio Santinelli

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

you could hack the pg_dump bit out of phpPgAdmin i think the license permits it. just my 2 cents. jeff On Wed, 9 May 2001, Jack wrote: Date: Wed, 9 May 2001 09:45:46 +1000 From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [SQL] execute client application from PL/pgSql Is that

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

Jack wrote: 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

Re: [SQL] Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement

David D. Kilzer [EMAIL PROTECTED] writes: [ wants to write an aggregate function that returns its last input ] The SQL model of query processing has a very definite view of the stages of processing: first group by, then aggregate, and last order by. Tuple ordering is irrelevant according to

Re: [SQL] Postgres function library

On Fri, May 11, 2001 at 08:48:01AM +0200, Lajtos Mate wrote: Hi all, I read the post from Josh Berkus where he (at the end of the message) mentions a 'function library'. Is that library available for any developer or it's a proprietary one? If it's public, can I post functions there?

Re: [SQL] Is this possible?

On Tue, May 08, 2001 at 09:16:56PM -0400, Wei Weng wrote: I have a table that has a serial for primary key. Is it possible to get the new available primary key right after I insert a row of new entry? Yeah. Se the documentation on triggers. -Roberto -- +|

Re: [SQL] number of days in a month

does it exist a date function to determine the number of days in a Select, knowing a specifique date ? January, 2001: select '2001-2-1'::datetime - '2001-1-1'::datetime; -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts,

Re: [SQL] Re: How to store gif or jpeg? Thanks!

On Tue, May 08, 2001 at 03:16:53PM +0200, Sylte allegedly wrote: src/interfaces/jdbc/example/ImageViewer.java Somewhere on the internet Please be more specific It's part of the PostgreSQL source. You can download the PostgreSQL source from www.postgresql.org... Regards, Mathijs --

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 could hack