This look like it would be nice to have it configurable.
first_day_of_the_week
first_day_of the_year
Tom Lane wrote:
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
Frankly speaking I don`t know the adequate calendar ISO norm in detail, but
the last days of year shouldn`t be counted as F_I_R_
This means that there is no more difference between CHAR(N) and
VARCHAR(N). To bad... '1 ' sould be different from '1'.
Tom Lane wrote:
Josh Berkus <[EMAIL PROTECTED]> writes:
Are these changes intentional,
Yes. We've been moving more and more steadily towards the notion that
trailing spaces in
3 and '003 ' are not the samething!!!
Do not forget that F1 and F2 are paded with spaces also.
Maybe you want to use varchar instead.
Ilir Gashi wrote:
Hello,
I saw this 'bug' reported in the Firebird SourceForge website for the
Firebird 1.0 server. They confirmed it as a bug! I tried it in
Postg
Rod,
If the table has 100,000 tupples your query is generating 100,000 new
tupples...
Try:
select * from quotes where id = (
select int8( 1 + random() * (
select id from quotes order by id desc limit 1)));
JLL
Rod Taylor wrote:
>
> > select * from quotes where id=1+round(random()* cast (
There is no error reported when a field in the subselect is not part of
the subselect table
but exists in the main table.
Try This:
nsd=# create table a ( f1 int, f2 text);
CREATE
nsd=# create table b ( f3 int, f4 text);
CREATE
nsd=# select * from a where f1 in ( select f1 from b);
f1 | f2
---
Lamar Owen wrote:
>[...]
> > 2) when postgres is launched the script do:
> > echo " [ OK ] "
> > but should be more correctly:
> > echo_success
>
> Hmmm. I thought that used to work right let me check.
It will work the same (if the format did not change), but I can mod
Hello Marques,
Your problem is that the oid is not indexed.
Create an index on photos(oid) then add the constraint separately.
JLL
Marques Johansson wrote:
>
> See the ERROR and comments below...
>
> create table photos (
> filename varchar[128] not null,
> filesize int default null,
>
the field numbers.
Someone should look into this. I think it is a bug.
JLL
Jean-Luc Lachance wrote:
>
> Any idea why when I call this function the record are not processed in
> the order requested?
>
> JLL
>
> P.S.
>
> It would be nice if the syntax would allow
Subject says it all
JLL
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Another one who decided to turn on the vacation auto reply.
Can some one unsubscribe him temporarely.
Adam Doligalski wrote:
>
> W dniu dzisiejszym jestem na urlopie.
>
> Jesli sa jakies sprawy nie cierpiace zwloki - prosze skontaktowac sie ze mna pod
>numerem telefonu 607225738.
>
> Adam
sult as
your initial query.
You would get something like:
WHERE ( "afd" < 'fb' )
or ( "afd" = 'fb' and "dss" < 13)
or ( "afd" = 'fb' and "dss" = 13 and "dat" < '2002080719163600'
Bonjour Frederik,
Seems to me that instead of
WHERE ( "afd" = 'fb' and "dss" = 13 and "dat" < '2002080719163600' )
or ( "afd" = 'fb' and "dss" <13 ) or ( "afd" < 'fb' )
ORDER BY "afd" DESC , "dss" DESC , "dat" DESC LIMIT 1;
you can write:
WHERE ( "afd", "dss", "dat") <= ('fb
Tom,
I believe not. This is the error message I get.
psql: relocation error: psql: undefined symbol: rl_completion_matches
Tom Lane wrote:
>
> Jean-Luc Lachance <[EMAIL PROTECTED]> writes:
> > Hitting TAB while editing a line crashes PSQL.
>
> Not here.
>
Just want to validate this one.
Hitting TAB while editing a line crashes PSQL.
File completion is meaningless here.
What is it supposed to complete any way?
JLL
P.S. on 7.2.1
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Jose,
First, do not waste your time comparing PG to MySql: MySql IS NOT SQL!
Second, any operation on NULL is NULL.
Third, no set can include NULL.
You want to rewrite your query as:
select * from t where b in (11,22) or b is null;
jose wrote:
>
> Hi all,
>
> I think I found a bug using the I
psql -c "COPY table FROM STDIN DELIMITERS ':'" < data.txt
hangs without warning when supplied with more field than the actual
table.
JLL
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
16 matches
Mail list logo
