Erik Jones <[EMAIL PROTECTED]> writes:
> ... The usual answer, or argument against, is because the
> standard dictates that the order of attributes in rows returned by
> queries is undefined in the absence a specified (in the query) ordering.
I don't think this is true. The spec is explicit t
On 8/24/07, Robert Treat <[EMAIL PROTECTED]> wrote:
> On Friday 24 August 2007 17:18, Matthew wrote:
> > Hey Bill,
> >
> > > It does not.
> >
> > Bummer.
> >
> > > To get your columns in a specific order, specify the column names in
> > > that order in your SELECT statement. The SQL standard
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This kind of disappointing, I was hoping there was more that could be
done.
There has to be another way to do incremental indexing without
loosing that much performance.
Benjamin
On Aug 24, 2007, at 6:29 PM, Joshua D. Drake wrote:
-BEGI
On Aug 24, 2007, at 4:18 PM, Matthew wrote:
Hey Bill,
It does not.
Bummer.
To get your columns in a specific order, specify the column names in
that order in your SELECT statement. The SQL standard doesn't
provide
for any other way to guarantee column order, and neither does
"Tom Lane" wrote in message news:[EMAIL PROTECTED]:
> "Stuart" <[EMAIL PROTECTED]> writes:
> >> I can't find an option in psql to connect to a database
> >> by "service" name? Should there be one?
>
> In 8.3 libpq will have code that interprets what's usually the database
> name parameter as a "
"Stuart" <[EMAIL PROTECTED]> writes:
>> I can't find an option in psql to connect to a database
>> by "service" name? Should there be one?
In 8.3 libpq will have code that interprets what's usually the database
name parameter as a "conninfo" string if there's an "=" in it, which
means you can ge
> Cody Pisto <[EMAIL PROTECTED]> writes:
> > If initdb was done with a C locale, and thus lc_collate and friends
> > where all C, but the database and client encoding was set to UTF-8,
> > would postgres convert data on the fly from UTF-8(storage) to ASCII for
> > sorting or would things just bl
"Stuart" wrote in message news:[EMAIL PROTECTED]:
> I can't find an option in psql to connect to a database
> by "service" name? Should there be one?
Sorry for folowing up my own post but since I got asked in
email, and since I wrote code to do essentially the same thing
before noticing it in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Brandon Shalton wrote:
> Benjamin,
>
>
>>
>> In order to avoid the re-indexing I was thinking of instead creating
>> a new
>> table each month (building its indexes and etc) and accessing them all
>> through a view. This way I only have to index the
Cody Pisto <[EMAIL PROTECTED]> writes:
> If initdb was done with a C locale, and thus lc_collate and friends
> where all C, but the database and client encoding was set to UTF-8,
> would postgres convert data on the fly from UTF-8(storage) to ASCII for
> sorting or would things just blow up when
On 25/08/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> On Fri, 24 Aug 2007, Phoenix Kiula wrote:
>
> > Hi,
> >
> > We have big blobs of text (average 10,000 characters) in a database,
> > from which we would like to discover the most often repeated words or
> > phrases. Can tsearch be used for thi
Benjamin,
In order to avoid the re-indexing I was thinking of instead creating a
new
table each month (building its indexes and etc) and accessing them all
through a view. This way I only have to index the new data each month.
Take a look at bizgres.org (based on postgres).
They have a
Hi,
I have an application which loads millions of NEW documents each month
into a PostgreSQL tsearch2 table. I have the initial version completed
and searching performance is great but my problem is that each time a
new
month rolls around I have to drop all the indexes do a COPY and re-index
I can't find an option in psql to connect to a database
by "service" name? Should there be one?
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
Hi Tom,
I did understand what you said, I apologize that it came out otherwise.
I'm just looking for the correct workaround.
If initdb was done with a C locale, and thus lc_collate and friends
where all C, but the database and client encoding was set to UTF-8,
would postgres convert data on t
On Friday 24 August 2007 17:18, Matthew wrote:
> Hey Bill,
>
> > It does not.
>
> Bummer.
>
> > To get your columns in a specific order, specify the column names in
> > that order in your SELECT statement. The SQL standard doesn't provide
> > for any other way to guarantee column order, and
Alexander Staubo wrote on 24.08.2007 23:49:
So actually the remark shouldn't be that "the multi-threaded
architecture is only advantageous on Windows", but more like "the
multi-process architecture is disadvantageous on Windows and hence a
multi-threaded architecture is preferred (on that partic
Cody Pisto <[EMAIL PROTECTED]> writes:
> If this is potentially a problem in postgres somewhere, point me in the
> general direction and I'm more than willing to fix it myself..
You seem not to have absorbed what I said. This *is* the correct result
according to that locale's definition of sorti
On 8/24/07, Dave Page <[EMAIL PROTECTED]> wrote:
> Alban Hertroys wrote:
> > So actually the remark shouldn't be that "the multi-threaded
> > architecture is only advantageous on Windows", but more like "the
> > multi-process architecture is disadvantageous on Windows and hence a
> > multi-threade
On Aug 24, 2007, at 2:18 PM, Matthew wrote:
Hey Bill,
It does not.
Bummer.
To get your columns in a specific order, specify the column names in
that order in your SELECT statement. The SQL standard doesn't
provide
for any other way to guarantee column order, and neither does
Hey Bill,
> It does not.
Bummer.
> To get your columns in a specific order, specify the column names in
> that order in your SELECT statement. The SQL standard doesn't provide
> for any other way to guarantee column order, and neither does Postgres.
Yes, I realize this and we d
In response to Matthew <[EMAIL PROTECTED]>:
> Hi gang,
> In MySQL it is possible to add a column before/after another column. I
> have not been able to find such syntax in the Postgres manual. Does this
> ability exist?
It does not.
> Is my only solution to create a new table with the new colu
Hi gang,
In MySQL it is possible to add a column before/after another column. I
have not been able to find such syntax in the Postgres manual. Does this
ability exist?
Is my only solution to create a new table with the new column, copy the
data, delete the old table and rename the new one?
TIA,
Hi Tom,
Thanks for answering,
I pretty much assumed that was the case (whatever library postgres is
using for encoding is causing the "issue")
The[my] problem is, it just seems like completely incorrect behavior..
The quickest and dirtiest examples I can do are that both python and
mysql s
Cody Pisto <[EMAIL PROTECTED]> writes:
> I'm looking for any kind of a reason (and potential workarounds), be it
> bug or otherwise, why the following two queries produce different
> results under a database encoding of UTF8 and lc_collate of en_US.UTF-8:
That's just how it is in most non-C loca
On Aug 24, 2007, at 4:09 AM, Alban Hertroys wrote:
I'm not entirely sure what makes multi-threading be advantageous on a
specific operating system, but I think FreeBSD should be added to that
list as well... They've been bench marking their threading support
using
multi-threading in MySQL (n
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Gregory Stark <[EMAIL PROTECTED]> writes:
>> "Tom Lane" <[EMAIL PROTECTED]> writes:
>>> There are a few old bits of code that still use MAKE_PTR/MAKE_OFFSET,
>>> but I think it's mostly just that no one's bothered to rewrite the code
>>> for SHM_QUEUE linke
Bill Thoen <[EMAIL PROTECTED]> writes:
> I'm a bit out of my depth with using these debugging tools and
> interpreting their results, but I think the problem is due to the output
> being just too big for interactive display.
Well, I can certainly believe it's related to the amount of data
involv
Shelby Cain <[EMAIL PROTECTED]> writes:
> Assuming this is an issue with shared libraries, I think it would have more=
> to do with the way Windows resolves address conflicts on process startup t=
> han anything caused by explicit calls to LoadLibrary(). Looking at postgre=
> s.exe with the depen
I'm a bit out of my depth with using these debugging tools and
interpreting their results, but I think the problem is due to the output
being just too big for interactive display. Using the same query with
tighter limits in the WHERE clause works perfectly. When I changed the
SQL script to writ
Tom Lane escribió:
I'm not sure if you have a specific technical meaning of "clone" in mind
here, but these processes are all executing the identical executable,
and taking care to map the shmem early in execution *before* they load
any DLLs. So it should work. Apparently, it *does* work for aw
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Amiel wrote:
> --- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
>
>
>> We are actually diagnosing a similar problem on this
>> end, where we get a
>> failure at 1920... I am currently trying to get some
>> DEBUG output.
>
> We are actually gett
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> We are actually diagnosing a similar problem on this
> end, where we get a
> failure at 1920... I am currently trying to get some
> DEBUG output.
We are actually getting it semi-regularly today (3
times already)I would be happy to provide s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Erik Jones wrote:
> On Aug 24, 2007, at 11:46 AM, Tom Lane wrote:
>
>> Jeff Amiel <[EMAIL PROTECTED]> writes:
>>> Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848
>>> local0.warning] [6-1] 2007-08-22 18:08:24 CDT ERROR:
>>> out of memory.
>>> Aug 2
Hi All,
I'm looking for any kind of a reason (and potential workarounds), be it
bug or otherwise, why the following two queries produce different
results under a database encoding of UTF8 and lc_collate of en_US.UTF-8:
SELECT x FROM (SELECT 'Something else' AS x UNION SELECT '-SOMETHING
ELSE
On Fri, 24 Aug 2007, Phoenix Kiula wrote:
Hi,
We have big blobs of text (average 10,000 characters) in a database,
from which we would like to discover the most often repeated words or
phrases. Can tsearch be used for this kind of pattern search? I
suppose it's Text Mining 101 sort of stuff, no
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>> There are a few old bits of code that still use MAKE_PTR/MAKE_OFFSET,
>> but I think it's mostly just that no one's bothered to rewrite the code
>> for SHM_QUEUE linked lists. The vast majority of our shmem struc
I apologize for resending this but my editor in combination with Yahoo's web
mail interface horribly mangled it...
>- Original Message
>From: Magnus Hagander <[EMAIL PROTECTED]>
>To: Shelby Cain <[EMAIL PROTECTED]>
>Cc: Alvaro Herrera <[EMAIL PROTECTED]>; Terry Yapt <[EMAIL PROTECTED]>;
On Aug 24, 2007, at 11:46 AM, Tom Lane wrote:
Jeff Amiel <[EMAIL PROTECTED]> writes:
Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848
local0.warning] [6-1] 2007-08-22 18:08:24 CDT ERROR:
out of memory.
Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848
local0.warning] [6-2] 2007-08-22 18:08:24
Bill Thoen <[EMAIL PROTECTED]> writes:
> (gdb) bt
> #0 0x003054264571 in fputc () from /lib64/libc.so.6
> #1 0x0040dbc2 in print_aligned_text (title=0x0, headers=0x5665d0,
> cells=0x2f8fc010, footers=0x557c90,
> opt_align=0x557ef0 'l' , "rr", 'l' times>, "rl lll", opt
>- Original Message
>From: Magnus Hagander <[EMAIL PROTECTED]>
>To: Shelby Cain <[EMAIL PROTECTED]>
>Cc: Alvaro Herrera <[EMAIL PROTECTED]>; Terry Yapt <[EMAIL PROTECTED]>;
>pgsql-general@postgresql.org
>Sent: Friday, August 24, 2007 1:08:44 AM
>Subject: Re: [GENERAL] FATAL: could not rea
Hi,
Gregory Stark wrote:
Only if your application is single-threaded. By single-threaded I don't refer
to operating system threads but to the architecture. If you're processing a
large batch file handling records one by one and waiting for each commit
before proceeding then it's single threaded.
Jeff Amiel <[EMAIL PROTECTED]> writes:
> Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848
> local0.warning] [6-1] 2007-08-22 18:08:24 CDT ERROR:
> out of memory.
> Aug 22 18:08:24 db-1 postgres[16452]: [ID 748848
> local0.warning] [6-2] 2007-08-22 18:08:24 CDT
> DETAIL: Failed on request of s
Hi,
Matthew wrote:
Hey all, new postgres user here. We are trying to setup/research an
HA/Replicated solution with Postrgresql between a datacenter in LA and a
d.c. in NY.
We have a private LAN link between the two D.C.'s with a max round-trip
of 150ms.
We will have a web server at each d.c. (
"Tom Lane" <[EMAIL PROTECTED]> writes:
> There are a few old bits of code that still use MAKE_PTR/MAKE_OFFSET,
> but I think it's mostly just that no one's bothered to rewrite the code
> for SHM_QUEUE linked lists. The vast majority of our shmem structures
> use regular pointers, and have for yea
Tom Lane escribió:
> There are a few old bits of code that still use MAKE_PTR/MAKE_OFFSET,
> but I think it's mostly just that no one's bothered to rewrite the code
> for SHM_QUEUE linked lists. The vast majority of our shmem structures
> use regular pointers, and have for years.
... except that
Le Friday 24 August 2007 17:09:16 Joshua D. Drake, vous avez écrit :
> > As long as we are talking about regex tools... I found this tool a while
> > back and today I don't know how I ever figured out regular expressions
> > without it. (http://www.regexbuddy.com/)
>
> Woah! That is great. Now to
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Trevor Talbot" <[EMAIL PROTECTED]> writes:
>> I gather postgres depends on it being at the same address, and fixing that
>> isn't trivial?
> I haven't been following the rest of the thread so I'm not sure if this is
> important. But no, fixing that shou
Hi,
We have big blobs of text (average 10,000 characters) in a database,
from which we would like to discover the most often repeated words or
phrases. Can tsearch be used for this kind of pattern search? I
suppose it's Text Mining 101 sort of stuff, nothing complex.
TIA!
---
On Aug 24, 2007, at 10:09 AM, Jeff Amiel wrote:
"PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by
GCC gcc (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath)"
Week-old installstill tuning and tweaking this
thing.
Over last 2 days, have spotted 10 "Out of Memory"
errors in postgres logs (nev
"Trevor Talbot" <[EMAIL PROTECTED]> writes:
> On 8/23/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
>> Not that wild a guess, really :-) I'd say it's a very good possibility -
>> but I have no idea why it'd do that, since all backends load the same
>> DLLs at that stage.
> Not a valid assumption;
> -Original Message-
> From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 24, 2007 10:09 AM
> To: Lee Keel
> Cc: Josh Trutwin; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] [OT - sorta] How to extract a substring using Regex
>
>
> Woah! That is great. Now to fi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lee Keel wrote:
>> -Original Message-
>>
>> ---(end of broadcast)---
>> TIP 4: Have you searched our list archives?
>>
>>http://archives.postgresql.org/
>
> As long as we are tal
Gregory Stark wrote:
> "Trevor Talbot" <[EMAIL PROTECTED]> writes:
>
> > I gather postgres depends on it being at the same address, and fixing that
> > isn't trivial?
>
> I haven't been following the rest of the thread so I'm not sure if this is
> important. But no, fixing that should be relative
"PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by
GCC gcc (GCC) 3.4.3 (csl-sol210-3_4-branch+sol_rpath)"
Week-old installstill tuning and tweaking this
thing.
Over last 2 days, have spotted 10 "Out of Memory"
errors in postgres logs (never saw before with same
app/usage patterns on tuned
Trevor Talbot wrote:
> On 8/23/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > Shelby Cain wrote:
>
> > > Wild guess on my part... could that error be the result of an attempt
> > > to map shared memory into a process at a fixed location that just
> > > happens to already be occupied by a dll t
"Ron Johnson" <[EMAIL PROTECTED]> writes:
> On 08/24/07 08:21, Markus Schiltknecht wrote:
>
>> This is commonly known as synchronous replication. As that involves
>> *at-least* one round-trip *before* committing, it's quite expensive. Can
>> you live with a delay of ~150ms before COMMIT confirmati
"Albe Laurenz" <[EMAIL PROTECTED]> writes:
> Would it be an option to have a checksum somewhere in each
> data block that is verified upon read?
That's been proposed before and rejected before. See the archives ...
regards, tom lane
---(end of bro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/24/07 08:21, Markus Schiltknecht wrote:
> Hi,
>
> Matthew wrote:
>> Hey all, new postgres user here. We are trying to setup/research an
>> HA/Replicated solution with Postrgresql between a datacenter in LA and a
>> d.c. in NY.
>>
>> We have a pr
Hi,
Did a little googling but didn't come up with much - does anyone know
if someone made an ERD of either the information_schema or system
catalog (pg_) tables for postgres 8?
Something similar to this for MySQL 5 would be ideal:
http://www.xcdsql.org/MySQL/information_schema/5.1/MySQL_5_1_INFO
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Josh Trutwin
> Sent: Friday, August 24, 2007 7:58 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] [OT - sorta] How to extract a substring using Regex
>
> On Fri, 24 Aug 200
Hi,
SELECT contentid, title, (rank(to_tsvector(body),q) +
rank(to_tsvector(title),q) + rank(to_tsvector(subtitle),q)) AS Score
FROM content, to_tsquery('parkyeri') AS q
WHERE statusid = 1
AND ispublished = 1
AND (to_tsvector(body) @@ q
OR to_tsvector(title) @@ q
OR to_tsvector(subti
"Trevor Talbot" <[EMAIL PROTECTED]> writes:
> I gather postgres depends on it being at the same address, and fixing that
> isn't trivial?
I haven't been following the rest of the thread so I'm not sure if this is
important. But no, fixing that should be relatively trivial as there are
already som
Hi. I hope this is the correct mailing list.
I am writing a function to extract data either from a table or a query
and output it in xml. I have the logic down, but I cannot work out a few
things.
1. How can I read the column headings from the returned data set? I have
resorted to writing th
Lange Marcus wrote:
Not that it matters in your case. The password might as well
be "password" - if they get access to the files/application,
it's game over.
What about having some of the columns encrypted in the database ?
Will that improve things abit ?
Not unless you can keep the key pro
> > Is there a way to assure that the database does not get
> stored on disk
> > ? If my program, everytime it starts, would create or build up the
> > database could this database be kept in RAM ? Or does postgres
> > automatically create a database file or something ? Do you
> understand
>
On Fri, 24 Aug 2007 06:31:58 +0100
Mark Cave-Ayland <[EMAIL PROTECTED]> wrote:
> > substring(data_field from '(.+)<\/name>')
>
> FWIW, I find the following site extremely useful when trying to
> create moderately complex regular expressions: http://www.rexv.org.
Nice site - here's another good o
On 24.08.2007 12:56, Bill Moran wrote:
How did you verify that? It will spawn a new connection silently, if the
old got dropped. Did you really verify your logs, that you don't get
more new connections than Apache spawns workers? This might not be
noticeable for you, if you are running Apache.
On 8/23/07, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> Shelby Cain wrote:
> > Wild guess on my part... could that error be the result of an attempt
> > to map shared memory into a process at a fixed location that just
> > happens to already be occupied by a dll that Windows had decided to
> > re
"Dave Page" <[EMAIL PROTECTED]> writes:
> Alban Hertroys wrote:
>> So actually the remark shouldn't be that "the multi-threaded
>> architecture is only advantageous on Windows", but more like "the
>> multi-process architecture is disadvantageous on Windows and hence a
>> multi-threaded architectu
In response to Hannes Dorbath <[EMAIL PROTECTED]>:
> > On 24.08.2007 02:43, Bill Moran wrote:
> >> Hannes Dorbath <[EMAIL PROTECTED]> wrote:
> >>> Bill Moran wrote:
> I guess I just feel that "broken" is a bit of a harsh term. If
> your expectations are for full-blown connection managem
Side note: Why does Thunderbird send HTML mails albeit being configured
for sending plain text mails? Sorry for that! And sorry for being off-topic.
Regards,
Christian
--
Deriva GmbH Tel.: +49 551 489500-42
Financial IT and Consulting Fax: +49 551 489500-91
H
Mikko Partio wrote:
Isn't 128MB quite low considering the "current standard" of 25%
- 50% of total ram?
I had also read a statement about using this amount of memory as shared
buffers. Exactly that was the reason why I set it to such a high value,
but I am now convinced that this
On Fri, Aug 24, 2007 at 12:07:37PM +0300, Mikko Partio wrote:
> On 8/23/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> > You've got it completely wrong. By setting shared_buffers to 2GB it
> > means no-one can use it. It's not postgres that's running out of
> > memory, it's the rest of you
try {
Object fs = this.resource.resolve(FeatureSource.class, new
GeoProgressMonitor(new NullProgressMonitor()));
if ((fs != null) && (fs instanceof FeatureSource))
{
FeatureCollection fc = ((FeatureSource) fs).getFeatures();
Hi. I hope this is the correct mailing list.
I am writing a function to extract data either from a table or a query
and output it in xml. I have the logic down, but I cannot work out a
few things.
1. How can I read the column headings from the returned data set? I
have resorted to writing the
On 8/23/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
>
>
> You've got it completely wrong. By setting shared_buffers to 2GB it
> means no-one can use it. It's not postgres that's running out of
> memory, it's the rest of your system. Set it to something sane like
> 128MB or maybe smaller.
Martijn van Oosterhout wrote:
You've got it completely wrong.
Hm, you seem to be right. :(
I have now decreased the "shared_buffers" setting to 128 MB. I have also
found some tuning pages with warnings about not setting the value too
high. I'm sure that I have read these pages before, but I s
Alban Hertroys wrote:
So actually the remark shouldn't be that "the multi-threaded
architecture is only advantageous on Windows", but more like "the
multi-process architecture is disadvantageous on Windows and hence a
multi-threaded architecture is preferred (on that particular OS)".
Yeah - bu
Dave Page wrote:
> Alban Hertroys wrote:
>> Joshua D. Drake wrote:
I agree with you on the multi-threaded. I think I will add a note
saying the the multi-threaded architecture is only advantageous on
Windows.
>>> And Solaris.
>>
>> I'm not entirely sure what makes multi-threading b
Lange Marcus wrote:
Ok. But apart from the risk with having the physical access to the
computer, would it be a reasonable safe solution to limit the access
with a password then ? So that, assuming a user does not have the
possibility to get any kind of root access, there is no way to read
or copy
Alban Hertroys wrote:
Joshua D. Drake wrote:
I agree with you on the multi-threaded. I think I will add a note
saying the the multi-threaded architecture is only advantageous on
Windows.
And Solaris.
I'm not entirely sure what makes multi-threading be advantageous on a
specific operating sy
Joshua D. Drake wrote:
>> I agree with you on the multi-threaded. I think I will add a note
>> saying the the multi-threaded architecture is only advantageous on
>> Windows.
>
> And Solaris.
I'm not entirely sure what makes multi-threading be advantageous on a
specific operating system, but I t
Tom Lane wrote:
>> - Shouldn't there be an error, some kind of 'missing magic
>> number' or similar, when a table file consists of only
>> zeros?
>
> The particular case of an all-zeroes page is specifically allowed,
> and has to be because it's a valid transient state in various
> scenarios.
On 24.08.2007 02:43, Bill Moran wrote:
Hannes Dorbath <[EMAIL PROTECTED]> wrote:
Bill Moran wrote:
I guess I just feel that "broken" is a bit of a harsh term. If
your expectations are for full-blown connection management from
pconnect(), then you will be disappointed. If you take it for
what
On 24.08.2007 00:43, Hannes Dorbath wrote:
Bill Moran wrote:
I guess I just feel that "broken" is a bit of a harsh term. If
your expectations are for full-blown connection management from
pconnect(), then you will be disappointed. If you take it for
what it is: persistent connections, then tho
Postgres User wrote:
> I'm new to Regex in Postgres. Can someone give me a quick pointer on
> how I'd SELECT the substring between ''and '' in
> a field?
>
> Sample field data:
> address city here Rogers, Jim zip code place
>
> and I'd like the SELECT to return only:
> Rogers, Jim
SELEC
87 matches
Mail list logo
