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
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
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
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.
>
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
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'
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
Subject says it all
JLL
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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
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,
>
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
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
---
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 (
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
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
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_
16 matches
Mail list logo
