[SQL] postmaster admin questions

Hi, we are using several Windows-clients to access a pg database on a linux machine. When we want to recreate/change the database "dropdb" says that there still are users connected to it. How can I see which users are connected and how can I disconnect them/ get my db dropped anyway?? Thank yo

[SQL] Order by email address by domain ?

Hi, I just want to order by a listing of email address by domain like : [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] Is it possible and how ? Thanks ! -- Hervé Piedvache Elma Ingenierie Informatique 6, rue du Faubourg Saint-Honoré F-75008 - Paris

Re: [SQL] Order by email address

Herve, > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > Is it possible and how ? Given the relational rule of Atomicity (each discrete piece of information shall have its own column or row), the solution is for you to make "e-mail id" and "

Re: [SQL] Order by email address

Herve, Etc. Ooops! A couple of misteaks in that last post: > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > Is it possible and how ? > > Given the relational rule of Atomicity (each discrete piece of > information shall have

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

I assume that you want to do this within the database, i.e. with a query. You would need to use a function, but I don't think a builtin function would do it. Try: CREATE FUNCTION email_order (text) RETURNS text AS ' select substr ($1, strpos ($1, ''@'') + 1) || substr ($1, 1, strpos ($1, ''@'') -1

[SQL] Escape Quotes

When using apostrophies the PostgreSQL string seems to like an escape character as follows: update client set code = 'O\'SHEA' where clientid = 2; The ANSI-92 standard seems to suggest that this could/should be handled by ::= ' ::= update client set code = 'O''SHEA' whe

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

Why is everyone else suggesting new functions? This works (in 6.5.3): ORDER BY lower(substring(email from position('@' in email)+1 )), lower(email) remove the lower() functions if you don't need them (I had mixed case addresses). I am guessing/assuming that it's cheaper to just use entire e

Re: [SQL] Escape Quotes

Keith Gray <[EMAIL PROTECTED]> writes: > Is it possible to get/configure PostgreSQL to handle > as within a dleimited string? We already do. regression=# select 'O''SHEA'; ?column? -- O'SHEA (1 row) regards, tom lane ---(end of broad

Re: [SQL] Escape Quotes

Keith Gray <[EMAIL PROTECTED]> writes: > This may be a problem in "ipgsql" then?? I guess. What is that, anyway? > ...or is it different in update from select? Nope, a literal is a literal. regards, tom lane ---(end of broadcast)---

Re: [SQL] Escape Quotes

Tom Lane wrote: > > Keith Gray <[EMAIL PROTECTED]> writes: > > Is it possible to get/configure PostgreSQL to handle > > as within a dleimited string? > > We already do. > > regression=# select 'O''SHEA'; > ?column? > -- > O'SHEA > (1 row) > > regards, tom la

[SQL] Re: Escape Quotes

> > > Is it possible to get/configure PostgreSQL to handle > > > as within a delimited string? > > > > We already do. > > > > This may be a problem in "ipgsql" then?? > ...or is it different in update from select? The problem is in ipqsql... it doesn't handle update, but does handle select.

Re: [SQL] Re: Escape Quotes

On Fri, May 11, 2001 at 01:17:41PM +1000, Keith Gray wrote: > > The problem is in ipqsql... What the heck is ipsql?? -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net h

[SQL] ipsql (was - Escape Quotes)

Roberto Mello wrote: > > What the heck is ipsql?? > > -Roberto ipgsql A Win32 client for interactive Postgres session Keith README Interactive PostgreSQL presents comfortable windows environment to execute sql queries, edit tables data, view tabl

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