Hello,
I have not Oracle, so I cannot test it, but PostgreSQL implementation
respect Oracle:
http://archives.postgresql.org/pgsql-patches/2005-06/msg00431.php
Regards
Pavel Stehule
2007/6/30, Bruno Wolff III <[EMAIL PROTECTED]>:
The following is just FYI.
I was recently doing some stuff with
Hello
PostgreSQL supports modifyable arrays. You have to respect some
specific (depend on version of postgresql). Array have to be
initialised (filled) for all pg versions older than 8.2.
create or replace function foo()
returns int as $$
declare a int[] = '{0,0,0,0,0,0,0,0,0,0}'; -- inicialis
Hi!
bond=> SELECT to_tsvector('default','animation animal');
to_tsvector
-
'anim':1,2
(1 row)
bond=>
Sorry for a silly question, I wonder, how do I override this? I would
want different stemmed words for these.
Best regards,
Marcus
---(end of broadcast)-
Mavinakuli, Prasanna (STSD) wrote:
> Hello All,
>
> We are looking for your help.The scenarion which we need to address
> is,There are 2 threads and both of them are in separate transction and
> insert the value to a same table and also sequence number field gets
> incremented automotically for ea
Pouria wrote:
> Hi,
>
> When I try to install pljava 1.3 on postgresql 8.2 (or 8.1) I get an
> error stating that it cannot load pljava.dll from a location
> specificed in the config file (while the dll is clearly there). I have
> followed the postgredql and pljava manual installation instructions
Bauhaus <[EMAIL PROTECTED]> schrieb:
> Hello,
>
> I'm an Access/SQL novice and I have an sql problem:
>
> I have the following table Price:
>
> FuelID PriceDate Price
> LPG1/05/2007 0,2
> LPG13/05/2007 0,21
> SPS 2/05/2007 1,1
> SPS 15/05/2007 1,08
>
> And I have to make
siva prakash wrote:
> if i run the setup choose language then go to next button it shows error
> *"Failed to create process: 2!*
Please don't remove the mailinglist from the CC list, so others can
learn from the answers.
The error you get indicates that your windows installation is broken. At
tha
On Fri, 22 Jun 2007 18:23:44 -0300
"Daniel van Ham Concrete" <[EMAIL PROTECTED]> wrote:
> >
> > # Insert four rows in regs (rID will go from 1 to 4):
> > insert into regs (name, number) values ('Daniel', 4);
> > insert into regs (name, number) values ('Daniel', 14);
> > insert into regs (name, num
"Bruno Wolff III" <[EMAIL PROTECTED]> writes:
> Also what value should I have used in a coalesce to guaranty still getting
> the maximum?
I would expect coalesce(coalesce(greatest(a,b),a),b) to do what you want. It's
not terribly legible though and if a and b are subselects I would worry a
little
"Tom Lane" <[EMAIL PROTECTED]> writes:
> GREATEST/LEAST aren't in the spec, so there's not much help there.
>
> Except ... if they ever do get added to the spec, what do you think
> the spec will say? The odds it'd contradict Oracle seem about nil.
Fwiw even in the min/max/sum case the spec is m
> --- Original Message ---
> From: Magnus Hagander <[EMAIL PROTECTED]>
> To: siva prakash <[EMAIL PROTECTED]>, "'PostgreSQL'"
>
> Sent: 30/06/07, 13:33:04
> Subject: Re: [GENERAL] postgressqlnot support inwindows 2000
>
> siva prakash wrote:
> > if i run the setup choose language then
Gregory Stark wrote:
> "Tom Lane" <[EMAIL PROTECTED]> writes:
>
> > GREATEST/LEAST aren't in the spec, so there's not much help there.
> >
> > Except ... if they ever do get added to the spec, what do you think
> > the spec will say? The odds it'd contradict Oracle seem about nil.
>
> Fwiw even
On Sat, 30 Jun 2007, Marcus Engene wrote:
Hi!
bond=> SELECT to_tsvector('default','animation animal');
to_tsvector
-
'anim':1,2
(1 row)
bond=>
Sorry for a silly question, I wonder, how do I override this? I would want
different stemmed words for these.
create synonym dictionary
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Bruno Wolff III" <[EMAIL PROTECTED]> writes:
>> Also what value should I have used in a coalesce to guaranty still getting
>> the maximum?
> I would expect coalesce(coalesce(greatest(a,b),a),b) to do what you want. It's
> not terribly legible though and
Gregory Stark <[EMAIL PROTECTED]> writes:
> Fwiw even in the min/max/sum case the spec is moving away from having
> aggregates ignore NULL values. You now get a warning in Oracle if your
> aggregate includes any NULL inputs.
I don't think there's any "moving" involved; as far back as SQL92 the
def
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
>> Fwiw even in the min/max/sum case the spec is moving away from having
>> aggregates ignore NULL values. You now get a warning in Oracle if your
>> aggregate includes any NULL inputs.
>
> How does Oracle's new behavior relate to the standard moving?
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Gregory Stark <[EMAIL PROTECTED]> writes:
>> "Bruno Wolff III" <[EMAIL PROTECTED]> writes:
>>> Also what value should I have used in a coalesce to guaranty still getting
>>> the maximum?
>
>> I would expect coalesce(coalesce(greatest(a,b),a),b) to do what y
Tom Lane wrote:
> Gregory Stark <[EMAIL PROTECTED]> writes:
> > Fwiw even in the min/max/sum case the spec is moving away from having
> > aggregates ignore NULL values. You now get a warning in Oracle if your
> > aggregate includes any NULL inputs.
>
> I don't think there's any "moving" involved;
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Anyway, there's no doubt that we can point to the behavior of MAX/MIN
>> as defense for what we made GREATEST/LEAST do, so I'm inclined to leave
>> their behavior alone, at least until such time as they're actually
>> standardized. But
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Anyway, there's no doubt that we can point to the behavior of MAX/MIN
> >> as defense for what we made GREATEST/LEAST do, so I'm inclined to leave
> >> their behavior alone, at least until such time as they're actu
Tom Lane wrote:
Anyway, there's no doubt that we can point to the behavior of MAX/MIN
as defense for what we made GREATEST/LEAST do, so I'm inclined to
leave
their behavior alone, at least until such time as they're actually
standardized.
I don't think I buy this - MIN and MAX are aggregate
On Sat, Jun 30, 2007 at 09:29:23 +0200,
Pavel Stehule <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have not Oracle, so I cannot test it, but PostgreSQL implementation
> respect Oracle:
>
> http://archives.postgresql.org/pgsql-patches/2005-06/msg00431.php
Maybe that reference was for an earlier ve
We pretty much ignore the spec's concept of non-error completion
conditions, but it sounds like Oracle tries to support it.
Anyway, there's no doubt that we can point to the behavior of MAX/MIN
as defense for what we made GREATEST/LEAST do, so I'm inclined to leave
their behavior alone, at least
Maybe that reference was for an earlier version of Oracle and the definition
changed at some point? I only have access to version 9 and greatest and
lest are strict there.
I am installing OracleXE and I'll test it.
Pavel
---(end of broadcast)---
At risk of putting my foot in my mouth again, greatest() returns null if one
or more expressions are null for Oracle enterprise 9.2.0.7 and 10.2.0.3.
The docs for greatest() don't talk of NULL:
SQL> select greatest(1,2,null,3) from dual;
GREATEST(1,2,NULL,3)
SQL> se
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Pavel Stehule
> Sent: Saturday, June 30, 2007 10:37 AM
> To: Bruno Wolff III; Pavel Stehule; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] greatest/least semantics different betwe
--- Magnus Hagander <[EMAIL PROTECTED]> wrote:
> If you're on 8.2 the easiest way is to use INSERT RETURNING. For example:
> INSERT INTO t (somefield) VALUES ('somevalue') RETURNING pkey
>
> with pkey being the SERIAL field.
I don't want to derail the thread too much, but would it be nice if th
You are correct. PostgreSQL implementation isn't compatible with
Oracle. It's question if the behave can be changed now.
Pavel
2007/6/30, paul rivers <[EMAIL PROTECTED]>:
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Pavel Stehul
Hi,
I have a pl/perl trigger function which can give an error, and I would like to
catch it in a pl/pgsql function, but I can't seem to trap it.
Is it possible to catch errors generated pl/perl functions in a BEGIN ...
EXCEPTION WHEN ... END block? Or perhaps in some other way?
A basic question about raising exceptions in Postgres:
If Function A calls Function B
and Func B raises an exception, will the exception roll back the
transaction in Func A by default? Or do I need to trap and re-raise
the exception in Func A?
Thanks.
---(end of bro
On Saturday 30 June 2007 23:14, Postgres User wrote:
> A basic question about raising exceptions in Postgres:
>
> If Function A calls Function B
>
> and Func B raises an exception, will the exception roll back the
> transaction in Func A by default? Or do I need to trap and re-raise
> the ex
Your query won't work because there is no single Price associated with
a range of dates. It doesn't make sense.
Do you mean to select AVG(Price)?
On 6/28/07, Bauhaus <[EMAIL PROTECTED]> wrote:
Hello,
I'm an Access/SQL novice and I have an sql problem:
I have the following table Price:
FuelI
How about this scenario:
func A()
begin
x = func B();
y = func C();
z = func D();
end
Where func A, B, C, and D all update the db. If a funciton is raised
in func D(), will all the transactions in the other children be rolled
back?
Or do I need to add code to enable this?
On 6/30
Where func A, B, C, and D all update the db. If an EXCEPTION is raised
in func D(), will all the transactions in the other children be rolled
back?
Or do I need to add code to enable this?
On 6/30/07, Postgres User <[EMAIL PROTECTED]> wrote:
How about this scenario:
func A()
begin
x = fun
On Saturday 30 June 2007 23:52, Postgres User wrote:
> How about this scenario:
>
> func A()
>
> begin
>x = func B();
>y = func C();
>
>z = func D();
>
> end
>
> Where func A, B, C, and D all update the db. If a funciton is raised
> in func D(), will all the transactions in t
In postgresql 8.2 I need a bitmap index for a certain column, but how do
I create it?
(No, a btree is not sufficient. :-) )
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Jun 30, 2007, at 18:23 , cluster wrote:
In postgresql 8.2 I need a bitmap index for a certain column, but
how do I create it?
(No, a btree is not sufficient. :-) )
Where do you see that PostgreSQL has bitmap indexes?
http://www.postgresql.org/docs/8.2/interactive/indexes-types.html
Po
37 matches
Mail list logo
