Hello all,
when I try to put a numeric 'timestamp' like 19980528112607 into an
int8-datatype I get the notice 'NOTICE: Integer input '19980528112607'
is out of range; promoted to float' and the value is put in the database
as 9223091508918288644.
It doesn't matter if I change the value: it wi
Hi, all!
Sorry for my English.
When I execute SQL-query from windows application using ODBC, I receive this message:
insert into jur(CUST,CUSTID,DOVER,EXEC,JURID,KURISP,KURZAK,NUMDOC, OSNOV,OT
PUSTIL,OTVOF,PARENTID,PLAT,POLUCHIL,PRIM,PRIM2, PRIMSCH,SODER,STATUS,TIPDOC
,VAL, DATDOC,FINISH, S
Hi,
this is a good day to ask this, or NOT??
How I can use the SET type, for to simulate the array behaivor
This type can be used for to represent a multivalued field in a table
Carlos Peralta Ramirez Thanks you
On Thu, 6 May 1999, Michael J Davis wrote:
> Try:
>
> select some_field
> from table
> where lower(another_field) like '%substring_entered_by_user%'
>
> -Original Message-
> From: Paulo Parola [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 0
Try:
select some_field
from table
where lower(another_field) like '%substring_entered_by_user%'
-Original Message-
From: Paulo Parola [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 06, 1999 3:53 PM
To: pgsql-general
Maybe not the fastest, but:
select some_field from table where lower(another_field) like
lower('%substring_entered_by_user%');
That will lower case the search field and item to do the match against.
--
Aaron Holtz
Hi,
When using mSQL I can perform case insensitive queries by using statements
like below:
select some_field
from table
where another_field clike '%substring_entered_by_user%'
How should I do that with PostgreSQL? (I understand 'clike' is not a
standard SQL feature and there is no simi
Hi!
I am updating from 6.3.2 to 6.4.2. Obviously I started by dumping my
databases, i.e.:
pg_dump database > database.sql
After the update, I restoring my databases, i.e.:
createdb database
psql database < database.sql
(interestingly pg_dump doesn't insert create database command, I think it
Louis Zirkel III wrote:
>I'm having trouble understanding how to get the crypt option working in
>the pg_hba.conf file. I can get cleartext passwords to be passed and they
>work just fine, but I cannot figure out how in the heck to get the crypt
>option working. I've looked through the F
I'm having trouble understanding how to get the crypt option working in
the pg_hba.conf file. I can get cleartext passwords to be passed and they
work just fine, but I cannot figure out how in the heck to get the crypt
option working. I've looked through the FAQ and found only a reference to
the
I'm seeing this in psql.
I think this is bad. What could cause this? It is a join between three
largish tables. I get loads of these.
Backend sent B message without prior T
Backend sent B message without prior T
Backend sent D message without prior T
Backend sent B message without prior T
Backe
11 matches
Mail list logo
