Alam Surya wrote:
> hello all..
>
> I have a litle question, do i have acces linux command from postgresql
> query like send message to others linux user in LAN ? any feature for that ?
You could use a system() call in a C function, or you could use Peter
Eisentraut's pl/sh language:
http:
Greg Stark wrote:
Ron St-Pierre <[EMAIL PROTECTED]> writes:
This is not quite what I need. I need to create a constraint to allow only
-one- of
company<->association<->default(=true) value
but any number of
company<->association<->default(=false) values
So a unique index on "(compan
Marc G. Fournier writes:
> As we are in the home stretch of a full release, we encourage as many as
> possible to test and report any bugs they can find, whether as part of the
> build process, or running in "real life" scenarios.
Folks, we still need verification of PostgreSQL 7.4 on certain pla
Ron St-Pierre <[EMAIL PROTECTED]> writes:
> No it doesn't. For example, after I create the unique index I can still input:
> company10 association7 true
> company10 association7 true
> company10 association7 true
> I want to prevent this from happening, but sti
On Tue, 4 Nov 2003, Dennis Gearon wrote:
> do I have to be a major guru or coder to be on the dev list?
Nope, anyone's welcome to join
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Tue, 4 Nov 2003, Ron St-Pierre wrote:
> Greg Stark wrote:
>
> >Ron St-Pierre <[EMAIL PROTECTED]> writes:
> >
> >
> >
> >>This is not quite what I need. I need to create a constraint to allow only
> >>-one- of
> >>company<->association<->default(=true) value
> >>but any number of
> >>com
Vivek Khera wrote:
"MGF" == Marc G Fournier <[EMAIL PROTECTED]> writes:
MGF> As we are in the home stretch of a full release, we encourage as
many as
MGF> possible to test and report any bugs they can find, whether as
part of the
MGF> build process, or running in "real life" scenario
"Edwin Quijada" <[EMAIL PROTECTED]> writes:
> I am trying to do a dump all and when I do this I get this error
> pg_dumpall: query failed: ERROR: Unable to convert abstime 'invalid' to
> timestamp
IIRC it is possible to get this error in some upgrade scenarios if you
have pg_shadow rows whose "
The above example in just one case where 'aid' can accept a null value.
That's not a null. It's a zero-length string.
I've found this is a feature of 7.3 to not treat a empty string as a
NULL integer type. Silly lazy me.
As it turned out it relatively trivial to fix the offending statements
For the record, it _never_ treated it as NULL. It treated it as
"empty string". '' != NULL. In fact, !(NULL=NULL) & !(NULL!=NULL).
SQL uses three-valued logic.
You're absolutely right. That explains why, when I quickly looked, some
are zero's and some are NULLs - the NULLs where NULLs and
On Tue, Nov 04, 2003 at 12:19:58PM +, Rob Fielding wrote:
> I've found this is a feature of 7.3 to not treat a empty string as a
> NULL integer type. Silly lazy me ;)
For the record, it _never_ treated it as NULL. It treated it as
"empty string". '' != NULL. In fact, !(NULL=NULL) & !(NULL!
Hello
You are on wrong way.
Try like
DECLARE
b RECORD;
s TEXT;
op TEXT;
BEGIN op := ''='';
s := ''SELECT 3 ''|| op || ''|| $1 || ''AS b'';
FOR b IN EXECUTE s LOOP
RETURN b.b;
END LOOP;
END;
Regards
Pavel
On Tue, 4 Nov 2003, Max Speransky wrote:
> Hello
>
> My task is to
Hi!
I am trying to do a dump all and when I do this I get this error
pg_dumpall: query failed: ERROR: Unable to convert abstime 'invalid' to
timestamp
pg_dumpall: query was: SELECT usename, usesysid, passwd, usecreatedb,
usesuper, CAST(valuntil AS timestamp) FROM pg_shadow WHERE usesysid <>
(SE
See my comments below.
On Tue, 2003-11-04 at 13:10, Victor SpÃng Arthursson wrote:
> Can't select 3 columns from a table called varer.
>
> The columns are the three first and are called vnummer, puNr and dNr.
>
> The error message is:
>
> indiadan=# select varer.vNummer from varer;
Jan Poslusny writes:
> Is some way to create two databases in the same database cluster
> with different encodings (specially utf-8 and iso 8859-2) and good
> sortings ?
No.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4:
RedHat 9, PostgreSQL 7.3.4.
When I perform
initdb --locale=cs_CZ
createdb --encoding=latin2 lat
createdb --encoding=unicode uni
, the tables of lat are sorted fine, but the tables of uni not. When I
initdb --locale=cs_CZ.UTF-8, sorts of uni are good, but sorts of lat
not. Is some way to create tw
Can't select 3 columns from a table called varer.
The columns are the three first and are called vnummer, puNr and dNr.
The error message is:
indiadan=# select varer.vNummer from varer;
ERROR: No such attribute varer.vnummer
indiadan=#
I'm probably doing something else wrong, but can't figure w
On Tue, Nov 04, 2003 at 12:19:58 +,
Rob Fielding <[EMAIL PROTECTED]> wrote:
>
> I've found this is a feature of 7.3 to not treat a empty string as a
> NULL integer type. Silly lazy me ;)
It didn't even then. It was treated as 0. Oracle is the DB that treats
empty strings as null values.
-
Hi,
I have a bit string , 7 bits, every bit representing a day of the week.
e.g. 1110011.
Is there and easy way where I can translate/format that string in a query.
I want to give the string back with a '-' for every 0 and the first char
of the Day for every '1'.
example 1100111 = SM--TFS.
than
Andrew Sullivan wrote:
On Tue, Nov 04, 2003 at 11:21:35AM +, Rob Fielding wrote:
Hi,
We're currently experiencing a problem where SQL statements are failing
when entring a '' for not not-null integer columns:
Yes. This behaviour was made more compliant in 7.3. It's in the
release notes
Hi,
We're currently experiencing a problem where SQL statements are failing
when entring a '' for not not-null integer columns:
ERROR: pg_atoi: zero-length string
This was discovered just after a database migration from 7.2 to 7.3.4.
Example:
insert into renewal_cache
(dom,
Hello
My task is to validate expression and get value of it in boolean variable.
I try to do following:
CREATE OR REPLACE FUNCTION get_value(integer) RETURNS boolean AS'
DECLARE
Ret boolean;
Op TEXT = ''='';
BEGIN
Ret := 3 || Op || $1;
RETURN Ret;
END;
' l
> -Ursprüngliche Nachricht-
> Von: Andrew Sullivan [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 4. November 2003 12:32
> An: [EMAIL PROTECTED]
> Betreff: Re: [GENERAL] pg7.3.4: pg_atoi: zero-length string
>
>
> On Tue, Nov 04, 2003 at 11:21:35AM +, Rob Fielding wrote:
> > We're cur
On Tue, Nov 04, 2003 at 11:21:35AM +, Rob Fielding wrote:
>
>
> Hi,
>
> We're currently experiencing a problem where SQL statements are failing
> when entring a '' for not not-null integer columns:
Yes. This behaviour was made more compliant in 7.3. It's in the
release notes.
> The abov
On Tuesday 04 November 2003 10:54, Alex wrote:
> Hi,
>
> I have a bit string , 7 bits, every bit representing a day of the week.
> e.g. 1110011.
> Is there and easy way where I can translate/format that string in a query.
> I want to give the string back with a '-' for every 0 and the first char
>
On Tuesday 04 November 2003 10:06, Max Speransky wrote:
> Hello
>
> My task is to validate expression and get value of it in boolean variable.
> I try to do following:
> Ret := 3 || Op || $1;
> RETURN Ret;
> bill=# select get_value(3);
> WARNING: Error occurred while executing PL
26 matches
Mail list logo