On 4 Dec 2002 at 8:13, Tommi Maekitalo wrote:
> I thought MySQL is marked as obsolete since PostgreSQL 7.3 ;-)
If you ask me, one should never under-estimate the compitition..No matter how
big upper hand you have..
If you want to compete in the first place, that is..
Bye
Shridhar
--
Ogden's
Hi,
I thought MySQL is marked as obsolete since PostgreSQL 7.3 ;-)
Tommi
Am Mittwoch, 4. Dezember 2002 03:55 schrieb Christopher Kings-Lynne:
> Not that anyone cares, but I notice in the commit logs for MySQL 4.1, it
> now has subselects.
>
> Chris
>
>
> ---(end of broad
Hi:
We at the Department of Information Technology of the Mindanao State
University-Iligan Institute of Technology (MSU-IIT) in Iligan City,
Philippines had been using PostgreSQL since 1998 in teaching courses in
Databases, SQL, and as a support tool in teaching Software Engineering and
Web App
Not that anyone cares, but I notice in the commit logs for MySQL 4.1, it now
has subselects.
Chris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Ok, I nailed the bug, but i'm not sure what the correct fix is.
Attached tsearch_morph.diff that remedies this problem by avoiding it.
Also there's a debug aid patch if someone would like to know how i
finally found it out :)
There problem in the lemmatize() function is that GETDICT(...) returned
Peter Eisentraut wrote:
Justin Clift writes:
Of course we are, it's just that we're also trying to direct people to
the Advocacy site where there is a lot more info, in a lot more languages.
Why don't we just shut down the regular web site. Clearly it's not
considered adequate anymore.
We
Peter Eisentraut wrote:
Marc G. Fournier writes:
Yup, as with doing anything for the firs ttime, the press release itself
had its 'bugs' ... considering how many times Josh asked for comments on
it, I'm surprised that nobody picked up on it *shrug*
And how should we have guessed that release
Justin Clift writes:
> Of course we are, it's just that we're also trying to direct people to
> the Advocacy site where there is a lot more info, in a lot more languages.
Why don't we just shut down the regular web site. Clearly it's not
considered adequate anymore.
--
Peter Eisentraut [EMAI
Marc G. Fournier writes:
> Yup, as with doing anything for the firs ttime, the press release itself
> had its 'bugs' ... considering how many times Josh asked for comments on
> it, I'm surprised that nobody picked up on it *shrug*
And how should we have guessed that release management is now done
Marc G. Fournier wrote:
Actually, there are lines, Justin just occasionally appears to 'blur' them
until I get a chance to refresh them ... eh Justin?:)
[innocent whistle]
+ Justin
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comma
Dave Page wrote:
I could have sworn we used to have a bunch of ftp mirrors for downloads.
Come to think of it I rewrote/stole a load of Vince's PHP code to allow
you to select one from the portal recently. Are we not using them
anymore?
Of course we are, it's just that we're also trying to dire
Marc G. Fournier wrote:
On Tue, 3 Dec 2002, Justin Clift wrote:
Excellent. Are there any other people involved in PostgreSQL and
universities or educational institutions? If so we could put something
together about experiences for the advocacy Web site.
Is this the kind of thing that the Tech
Joe Conway writes:
> That is one thing I'd like to take a look at. I think the problem is that
> certain byte-sequence/multibyte-encoding combinations are illegal, so it's not
> as simple an issue as it might first appear.
The bytea type really shouldn't come even close to having to care about
th
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Ok, someone else posted their data warehousing wishlist, I want to post my
> > single item OLP wishlist: Plan stability.
>
> That seems to me to translate to "I want the system to fail to react to
> changes in data
On Tue, 3 Dec 2002, Marc G. Fournier wrote:
> On Tue, 3 Dec 2002, Dave Page wrote:
>
> > I could have sworn we used to have a bunch of ftp mirrors for downloads.
> > Come to think of it I rewrote/stole a load of Vince's PHP code to allow
> > you to select one from the portal recently. Are we not u
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
>
> So, the problem may be in rh 7.3 ?
>
Might be, i'm debugging it now, and i can see that the dicts[] array in
morph.c is beeing overwritten with junk.
I can trigger it with this query:
select txt2txtidx('Can - Live 1971-77');
Is there any good way of
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
> >> I'll reinstall tsearch and try again soon.
> >> Is it necesary to install OpenFTS contrib aswell, or do i get away
> >> with only installing tsearch?
> >> Now i do both...
> >
> > Can you give u
> The one good reason for making it possible to use raw partitions is to
> make it possible to use the PostgreSQL engine as a filesystem! :-)
Hmm.. Something just doesn't seem right about that thought ;)
CREATE DATABASE filesystem;
\c filesystem
CREATE EXPORT /mnt AS NFS;
\q
mount_nfs -o port
On Tue, 3 Dec 2002, Vince Vielhaber wrote:
> Haven't you been paying attention? There's this new advocacy and suit
> marketing thing going on that makes all of that irrelevant. It's just
> there for show now.
---(end of broadcast)---
TIP 3: if p
On Tue, 3 Dec 2002, Dave Page wrote:
> I could have sworn we used to have a bunch of ftp mirrors for downloads.
> Come to think of it I rewrote/stole a load of Vince's PHP code to allow
> you to select one from the portal recently. Are we not using them
> anymore?
Yup, as with doing anything for
Hi ...
I just wanted to admit that an important collegue in Vienna already uses
PostgreSQL instead of Oracle which makes me really proud :).
We have done a training course this year and they use PostgreSQL instead
of free Oracle
I am happy that Austrian students are tortured with the things I ha
Hi,
it there anybody out there, who could correct this annoying
javascript-redirection at gborg.postgresql.org? If you go to
http://gborg.postgresql.org and select "Database administration tools" there
is a javascript-script (??), which redirects the browser to sourceforge.
Tommi
---
On 3 Dec 2002 at 15:08, Vince Vielhaber wrote:
> Where have you been? The lines of distinction between all of the
> lists have gotten so blurred it hardly makes a difference.
So consider this a wake up call.
--
Dan Langille : http://www.langille.org/
---(end of broadca
Al Sutton wrote:
> Point to Point and Broadcast replication
>
> With point to point you specify multiple endpoints, with broadcast you can
> specify a subnet address and the updates are broadcast over that subnet.
>
> The difference being that point to poin
On Tue, 3 Dec 2002, Dave Page wrote:
>
>
> > -Original Message-
> > From: Marc G. Fournier [mailto:[EMAIL PROTECTED]]
> > Sent: 03 December 2002 19:12
> > To: Bruce Momjian
> > Cc: PostgreSQL-development
> > Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global
> > Development Group Announces
> -Original Message-
> From: Marc G. Fournier [mailto:[EMAIL PROTECTED]]
> Sent: 03 December 2002 19:12
> To: Bruce Momjian
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global
> Development Group Announces
>
>
> On Thu, 28 Nov 2002, Bruce Momjian wrote:
>
On Tue, 3 Dec 2002, Vince Vielhaber wrote:
> On Tue, 3 Dec 2002, Marc G. Fournier wrote:
>
> > On Tue, 3 Dec 2002, Justin Clift wrote:
> >
> > > > Excellent. Are there any other people involved in PostgreSQL and
> > > > universities or educational institutions? If so we could put something
> > > >
Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
>
> Works on FreeBSD/Alpha for me. Maybe you've got some weirdness with
> bad RAM chips or something?
>
> Chris
Could be, but it only shows when i do this, and the server has been up
for several months.
If everything else failes, i'll run memtest
> No i can't, it's not my data to give :(
OK
> But it doesn't matter since if you run "gmake installcheck" in
> contrib/tsearch it will explode.
>
> A funny thing is that i installed pg7.3 on an linux intel celeron system
> (rh8.0) w/128 mb memory, and THERE it works!
Works on FreeBSD/Alpha for
Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
>> I'll reinstall tsearch and try again soon.
>> Is it necesary to install OpenFTS contrib aswell, or do i get away
>> with only installing tsearch?
>> Now i do both...
>
> Can you give us the compressed text? I can try it on my installation
> and
On Tue, 3 Dec 2002, Marc G. Fournier wrote:
> On Tue, 3 Dec 2002, Justin Clift wrote:
>
> > > Excellent. Are there any other people involved in PostgreSQL and
> > > universities or educational institutions? If so we could put something
> > > together about experiences for the advocacy Web site.
>
> I'll reinstall tsearch and try again soon.
> Is it necesary to install OpenFTS contrib aswell, or do i get away with
> only installing tsearch?
> Now i do both...
Can you give us the compressed text? I can try it on my installation and
see if there's the same problem?
Chris
-
On Mon, 2 Dec 2002, Rod Taylor wrote:
> double precision | pg_catalog | round | double precision
> numeric | pg_catalog | round | numeric
> numeric | pg_catalog | round | numeric, integer
>
> Looks like round still exists to me.
Rod, you don't unde
On Mon, 2 Dec 2002, Joel Burton wrote:
> joel@joel=# select round('2.000'::numeric);
> round
> ---
> 2
> (1 row)
>
> joel@joel=# select round('2.000'::numeric,2);
> round
> ---
>2.00
> (1 row)
OK, but:
template1=# select round('2.001'::numeric);
round
---
2
(1 row)
> Brute force, of course!
>
> Seriously, I have hidden the cygwin environment and simply called it
> PostgreSQL. I am managing all he environment variables in my installer,
> and I am using Windows batch files to start bash which executes the
> PostgreSQL comands.
>
> I am using PGAdmin as the admi
On Tue, 2002-12-03 at 17:59, scott.marlowe wrote:
> On Fri, 29 Nov 2002, Prasanna Phadke wrote:
> > Catch all the cricket action. Download Yahoo! Score tracker
> Step 1: Get VC++ to run under unix...
Virtual Cricket++? I don't exactly see how this applies here.
(sorry)
-- vbi
--
this email i
Marc G. Fournier wrote:
> On Thu, 28 Nov 2002, Bruce Momjian wrote:
>
> > Wow, this sounds great.
> >
> > Where can I get a copy? Why would anyone use anything else? ;-)
>
> Well, if you read the announcement in its entirety, you would have
> noticed:
>
> "Source for this release is available
On Tue, 3 Dec 2002, Justin Clift wrote:
> > Excellent. Are there any other people involved in PostgreSQL and
> > universities or educational institutions? If so we could put something
> > together about experiences for the advocacy Web site.
>
> Is this the kind of thing that the Techdocs Guides a
On Thu, 28 Nov 2002, Bruce Momjian wrote:
> Wow, this sounds great.
>
> Where can I get a copy? Why would anyone use anything else? ;-)
Well, if you read the announcement in its entirety, you would have
noticed:
"Source for this release is available at:
http://advocacy.postgresql.org/downl
Teodor Sigaev <[EMAIL PROTECTED]> wrote:
>
> Sorry, I have no any idea. Just only full reinstall (with initdb
> and rm -rf /usr/local/pgsql) postgresql...
> Can you give me login on you computer for a several hours?
>
The thing is that when i ran the thing breakpointing on parsetext() at
the
As you wish...
This is a bt taken from a core file this time (the other ones were from
attached processes).
The whole thing has been recompiled with no additional compiler flags
(i.e. removed -march=athlon -O3), but still with --enable-debug
and --enable-cassert.
Sorry, I have no any idea. J
TODO updated. Thanks for the clarification.
---
Hannu Krosing wrote:
> On Tue, 2002-12-03 at 16:00, Bruce Momjian wrote:
> > Is WITH a TODO item?
>
> It is disguised as
>
> Exotic Features
> ===
>
> * Add sq
If we had received more complaints about the change during beta, we
would have added a mention that the change would be in 7.4. As we got
few complaints, the change went into 7.3, and it is mentioned in the
porting section of the release notes (last item):
* An empty string ('') is no longe
On Tue, 2002-12-03 at 16:00, Bruce Momjian wrote:
> Is WITH a TODO item?
It is disguised as
Exotic Features
===
* Add sql3 recursive unions
Which was added at my request in dark times, possibly when PostgreSQL
was called postgres95 ;)
This should be changed to two items
* Add SQ
Hi,
| > What is the solution of other dbs ( oracle, db2 .. ) to:
| > insert into table (num) value (''); ? |
| I assume they would fail too.
The Oracle behaviour is:
---
oracle> create table foonum (x number(5));
oracle> insert into foonum values ('');
oracle> select * from foonum;
+
Some more (useless) info.
objdump -x /lib/*.so /usr/lib/*.so /lib/i686/*.so /usr/kerberos/lib/*.so
/usr/local/pgsql/bin/* /usr/local/pgsql/lib/*.so | grep lemmatize
reviels only one lemmatize symbol.
The offending address 0x02d1 is not mapped anywhere in the address
space according to /proc/
On Fri, 29 Nov 2002, Prasanna Phadke wrote:
>
> Can anybody explain me, how to compile postgres source code in VC++.
>
> Catch all the cricket action. Download Yahoo! Score tracker
Step 1: Get VC++ to run under unix...
Just kidding. :-) Right now you can't.
pgsql 7.4 should support native W
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> Magnus, we need backtrace from 'make installcheck'
>
As you wish...
This is a bt taken from a core file this time (the other ones were from
attached processes).
The whole thing has been recompiled with no additional compiler flags
(i.e. removed -march=ath
> > Copy is another story all together. But I'd like a
> >
> > CREATE SCHEMA ... AS COPY ;
> >
>
> Wouldn't it be better to use pg_dump/pg_restore for that?
Perhaps.. But I'd really like to see some of these types of abilities
added to pg_admin.
--
Rod Taylor <[EMAIL PROTECTED]>
PGP Key:
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> Teodor Sigaev <[EMAIL PROTECTED]> wrote:
> > Pls, send backtrace... :)
> >
>
> I already have, twice.
Magnus, we need backtrace from 'make installcheck'
>
> Magnus
>
> ---(end of broadcast)---
> TIP 4
--On Tuesday, December 03, 2002 11:21:04 -0500 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
Ben-Nes Michael wrote:
Then Why not set it to NULL
Well, it is not NULL, though, it is ''. They are not the same in
strings (though for some dbms's they are), so I don't see why we would
do that for nume
Teodor Sigaev wrote:
Does it crashed?
# select txt2txtidx('Can - Live 1971-77');
Line txtidx.c:366 :
lemm = lemmatize(token, &lenlemm, type);
lemmatize() is defined in morph.c. Did you use another modules for
postgresql?
It seems to me that we see a name conflict. Function lemmatize is
de
I don't think many will be caught-out, since it's an overwhelmingly
daft thing to do anyway!
If you've got a numeric type column then assign numeric values to, not
strings. Or explicitly convert.
I'm sure all occurrences of this "in the wild" are due to sloppy
SQL...
For the record:
lkind@coul
Ben-Nes Michael wrote:
> Then Why not set it to NULL
Well, it is not NULL, though, it is ''. They are not the same in
strings (though for some dbms's they are), so I don't see why we would
do that for numerics.
> Seems logic as there is nothing between ''
>
> What is the solution of other dbs (
Teodor Sigaev <[EMAIL PROTECTED]> wrote:
> Pls, send backtrace... :)
>
I already have, twice.
Magnus
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Pls, send backtrace... :)
Magnus Naeslund(f) wrote:
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
Magnus,
what is an output of 'make installcheck' ?
As i said, it segfaults:
[root@fet1b tsearch]# gmake installcheck
gmake -C ../../src/test/regress pg_regress
gmake[1]: Entering directory `/usr/s
Teodor Sigaev <[EMAIL PROTECTED]> wrote:
> Does it crashed?
> # select txt2txtidx('Can - Live 1971-77');
>
>
> Line txtidx.c:366 :
> lemm = lemmatize(token, &lenlemm, type);
>
> lemmatize() is defined in morph.c. Did you use another modules for
> postgresql?
>
> It seems to me that we see a name c
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> Magnus,
>
> what is an output of 'make installcheck' ?
As i said, it segfaults:
[root@fet1b tsearch]# gmake installcheck
gmake -C ../../src/test/regress pg_regress
gmake[1]: Entering directory `/usr/src/postgresql-7.3/src/test/regress'
gmake[1]: `pg_re
Does it crashed?
# select txt2txtidx('Can - Live 1971-77');
Line txtidx.c:366 :
lemm = lemmatize(token, &lenlemm, type);
lemmatize() is defined in morph.c. Did you use another modules for postgresql?
It seems to me that we see a name conflict. Function lemmatize is defined in
somewhere also.
Rod Taylor wrote:
Why just restrict them to moving tables? What if someone wants to move a
function or an aggregate to another schema?
What if they want to copy it?
Copying might be tricky, but I'd be happy to help with moving everything
else around. Though I don't think sequences can move (
The change was made to tighten up the code to catch errors sooner.
There isn't much logic to making '' be 0, and no one could make a case
for keeping such a mapping.
---
Lee Kindness wrote:
> Was it necessary? No idea, you'
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> >
> > Please, tell us postgresql version. Did you reinstall tsearch after
> > upgrading ? Test-suite (data, sql) demonstrated the problem would be
> > nice.
> >
>
> pgsql 7.3, about 700mb text database with
Is WITH a TODO item?
---
Hannu Krosing wrote:
> On Tue, 2002-12-03 at 09:20, Dennis Bj?rklund wrote:
> > On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> >
> > > Now convert this query so that it only evaluates the date_part
More info, the gdb> sharedlibrary loaded some more symbols:
(gdb) bt
#0 0x02d1 in ?? ()
#1 0x401faf48 in parsetext (prs=0xbfffea60, buf=0x4277eb3c "Can - Live
1971-77", buflen=18) at txtidx.c:366
#2 0x401fb5e6 in txt2txtidx (fcinfo=0xbfffeaf0) at txtidx.c:487
#3 0x080ec45c in ExecMakeFunct
I don't see any 7.3 tag created when we did the 7.3 release. (I do see
the 7.3 branch.)
Marc, can a tag be added to match the 7.3 release tree?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard dr
Oleg Bartunov <[EMAIL PROTECTED]> wrote:
>
> Please, tell us postgresql version. Did you reinstall tsearch after
> upgrading ? Test-suite (data, sql) demonstrated the problem would be
> nice.
>
pgsql 7.3, about 700mb text database with product descriptions.
I'm working on isolation the behavior, t
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> I'm evaluating tsearch contrib module, and i get a backend crash when
> i'm about to use a tsearch function.
>
> When i issue
> update things set nidx=txt2txtidx(productname),
> didx=txt2txtidx(longdescription);
>
> The backend dies in a segfault.
>
Tom Lane <[EMAIL PROTECTED]> wrote:
>
> Be sure to eliminate the possibility that you're loading the wrong
> version of the .so (ie, loading a 7.2 tsearch.so into 7.3). People
> get bit by that quite frequently right after an upgrade ...
>
Well, this is a clean install, so that isn't a problem.
"Magnus Naeslund\(f\)" <[EMAIL PROTECTED]> writes:
> It's either that it can't load the lib (shouldn't it complain?) or it's
> a bad pointer.
Be sure to eliminate the possibility that you're loading the wrong
version of the .so (ie, loading a 7.2 tsearch.so into 7.3). People
get bit by that quite
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Magnus Naeslund(f)" <[EMAIL PROTECTED]> writes:
>> The backend dies in a segfault.
>
>> Backtrace:
>
>> #0 0x02d1 in ?? ()
>> #1 0x401faf48 in ?? ()
>> #2 0x401fb5e6 in ?? ()
>> #3 0x080d8f5c in ExecMakeFunctionResult (fcache=0x82d3710,
>> arguments=0x
"Magnus Naeslund(f)" <[EMAIL PROTECTED]> writes:
> The backend dies in a segfault.
> Backtrace:
> #0 0x02d1 in ?? ()
> #1 0x401faf48 in ?? ()
> #2 0x401fb5e6 in ?? ()
> #3 0x080d8f5c in ExecMakeFunctionResult (fcache=0x82d3710,
> arguments=0x82ce170, econtext=0x82d3580, isNull=0xbfffec8f
I am thinking of tweaking EXPLAIN so that it performs ExecutorStart()
and ExecutorEnd() even when you just do plain EXPLAIN (and not EXPLAIN
ANALYZE). The immediate reason for this is an internal change (details
below) but it would have a couple of user-visible side effects:
1. Permissions checki
I'm evaluating tsearch contrib module, and i get a backend crash when
i'm about to use a tsearch function.
When i issue
update things set nidx=txt2txtidx(productname),
didx=txt2txtidx(longdescription);
The backend dies in a segfault.
The system is redhat 7.3 dual athlon w/ 1GB memory.
Postgresql
[EMAIL PROTECTED] wrote:
I've looked long and hard and can't find any license issues. Does anyone
know of any that I may have missed? As far as I can see, as long as I
maintain GPL restrictions, I should be fine.
PostgreSQL isn't licensed under the GPL, so it sounds to me as though you'
> -Original Message-
> From: mlw [mailto:[EMAIL PROTECTED]]
> Sent: 03 December 2002 12:44
> To: Dave Page
> Cc: psqlodbc; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?
>
>
> Dave Page wrote:
>
> >
> >No problems with pgAdmin, though I do h
Dave Page wrote:
-Original Message-
From: mlw [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 06:17
To: psqlodbc; [EMAIL PROTECTED]
Subject: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?
I am working on getting a shrink-wrapped version of
PostgreSQL for Windows
Curre
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 03 December 2002 12:16
> To: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Shrinkwrap Windows Product, any
> issues? Anyone?
>
>
> > I've looked long and hard and can't find any license issues. Does
> > a
> I've looked long and hard and can't find any license issues. Does anyone
> know of any that I may have missed? As far as I can see, as long as I
> maintain GPL restrictions, I should be fine.
PostgreSQL isn't licensed under the GPL, so it sounds to me as though you're
confused about the licen
Was it necessary? No idea, you're welcome to search through the
pgsql-hackers archives to determine the reasoning behind the change. I
believe the change was made by Bruce Momjian (going by the release
notes). I only remember reading the discussion in passing.
This is also one of the reasons for b
On 3 Dec 2002, Hannu Krosing wrote:
> the standard way of doing it would be SQL99's WITH :
Great! I havn't looked too much at sql99 yet so I've missed this. It's
exactly what I want. Now I know what I will use in the future (when it's
all implemented).
--
/Dennis
---
I'm certainly interested! I am working here on Geographical Information
Systems with PostgreSQL/PostGIS with the Minnesota MapServer, with a lot
of regular database work thrown in. PostgreSQL has great potential for
teaching databases and SQL, and when the native Windows port is ready,
it will
On Tue, 2002-12-03 at 09:20, Dennis Björklund wrote:
> On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
>
> > Now convert this query so that it only evaluates the date_part thing
> > ONCE:
> >
> > select t.id, date_part('days',now()-t.stamp) from table_name t where
> > date_part('days',now()-t.stamp
On Mon, Dec 02, 2002 at 12:48:38PM -0800, Christopher Kings-Lynne wrote:
> But if there is, then the sum/count(*) is nonsensical anyway.
You must to use it in SERIALIZABLE transaction isolation.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
-
On Tue, 3 Dec 2002, Magnus Naeslund(f) wrote:
> Now convert this query so that it only evaluates the date_part thing
> ONCE:
>
> select t.id, date_part('days',now()-t.stamp) from table_name t where
> date_part('days',now()-t.stamp) > 20;
Something like this could work:
select *
from (select t
> -Original Message-
> From: mlw [mailto:[EMAIL PROTECTED]]
> Sent: 03 December 2002 06:17
> To: psqlodbc; [EMAIL PROTECTED]
> Subject: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?
>
>
> I am working on getting a shrink-wrapped version of
> PostgreSQL for Windows
>
> Cur
On Mon, Dec 02, 2002 at 08:56:41AM -0800, Joe Conway wrote:
> Karel Zak wrote:
> >On Sat, Nov 30, 2002 at 01:11:20PM -0800, Joe Conway wrote:
> >
> >>As I said, this is all very preliminary; comments, suggestions, requests
> >>are all welcome.
> >
> > Only idea/dream: what implement dblink as "vi
86 matches
Mail list logo
