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
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
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
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
> > > 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.
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
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)---
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
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
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
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
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
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 "
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
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
15 matches
Mail list logo