Josh Berkus [EMAIL PROTECTED] writes:
How can i create a function that accept and return any type. the type any
is not allowing as parameter or return type. Is it possible? i want to
create a function similar to NULLIF().
You can't, nor will you be able to -- in te future, some 7.4 functions
Hi
Iam using postgresql 7.3.x. I amupgrating a
databasePostgreSQL.
The main problem is how to change field last value in sequencde which
exists in database.
I created script to read this field and then I'mdrop the table, do
modification and i'm must change this value to another value.
But
Hi
I am using postgresql 7.3.x. I am upgrating a database PostgreSQL.
The main problem is how to change field last value in sequencde which
exists in database.
I created script to read this field and then I'm drop the table, do
modification and i'm must change this value to another value.
But
On Thu, 2003-09-25 at 07:36, Przemysaw Supkowski wrote:
Hi
I am using postgresql 7.3.x. I am upgrating a database PostgreSQL.
The main problem is how to change field last value in sequencde which
exists in database.
I created script to read this field and then I'm drop the table, do
On Thursday 25 September 2003 07:36, Przemysaw Supkowski wrote:
Hi
I am using postgresql 7.3.x. I am upgrating a database PostgreSQL.
The main problem is how to change field last value in sequencde which
exists in database. I created script to read this field and then I'm drop
the table, do
HI
Thanks for help I'm found this solution and this works, but I'm use
something like that
PERFORM setval(seq_name, value);
It looks better but thanks a lot
- Original Message -
From: Richard Huxton [EMAIL PROTECTED]
To: Przemysaw Supkowski [EMAIL PROTECTED]; Lista
dyskusyjna pgsql-sql
Hi All,
I have few questions, kindly suggest your comments on this..
1. Is that postgres supports distributed database ?
In oracle, by creating Dblink we can communicate the remorte
database from the local one. How you could implement this in postgres
database.
2. Is
Thanks richards ..i will go through that doc..
With Regards
Vijay
From: Richard Huxton [EMAIL PROTECTED]
To: vijaykumar M [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [SQL] few questions ..?
Date: Thu, 25 Sep 2003 11:07:00 +0100
On Thursday 25 September 2003 09:36, vijaykumar M wrote:
Hi
Thanks to all of you for your valuable suggesstions
does postgresql internally uses the = operator(text,text) for any other purposes.
i think that overloading it solves the index problem too...
Tom Lane [EMAIL PROTECTED] wrote:
Josh Berkus <[EMAIL PROTECTED]>writes: How can i create a
How is it possible to convert a database in SQL_ASCII to UNICODE ?
Thx a lot
Regards
Ben
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
In this week's General Bits, we talk about using
large objects. Perhaps this might help you understand
what is involved with using them.
http://www.varlena.com/GeneralBits/
cheers,
[EMAIL PROTECTED]
On Thu, Sep 25, 2003 at 09:41:28AM +0530, Kumar wrote:
Hi Friends,
I am running Postgres
I have the following rows (in addition to others):
acct_num text,
master_acct_num text,
These are in the same table.
What I want to enforce is that if the master_acct_num field is NOT NULL (it
can be NULL, and
that's fine), that the value appears in some row as acct_num. acct_num has
a unique
Uytkownik Larry Rosenman napisa:
I have the following rows (in addition to others):
acct_num text,
master_acct_num text,
These are in the same table.
What I want to enforce is that if the master_acct_num field is NOT
NULL (it can be NULL, and
that's fine), that the value appears in some row as
--On Thursday, September 25, 2003 20:59:25 +0200 Adam Wieckowski
[EMAIL PROTECTED] wrote:
U¿ytkownik Larry Rosenman napisa³:
I have the following rows (in addition to others):
acct_num text,
master_acct_num text,
These are in the same table.
What I want to enforce is that if the
On Thursday 25 September 2003 19:51, Larry Rosenman wrote:
I have the following rows (in addition to others):
acct_num text,
master_acct_num text,
These are in the same table.
What I want to enforce is that if the master_acct_num field is NOT NULL (it
can be NULL, and
that's fine), that
--On Thursday, September 25, 2003 20:09:35 +0100 Richard Huxton
[EMAIL PROTECTED] wrote:
On Thursday 25 September 2003 19:51, Larry Rosenman wrote:
I have the following rows (in addition to others):
acct_num text,
master_acct_num text,
These are in the same table.
What I want to enforce is
In my tsearch2.sql there are statements like :
--dict interface
CREATE FUNCTION lexize(oid, text)
returns _text
as '$libdir/tsearch2'
language 'C'
with (isstrict);
I don't think $libdir is the real value that we want. Do I need to set
some special parameters
I've created the following stored procedure to allow me to do
international-insensitive text searches, e.g. a search for Resume would
match the text Résumé.
I wanted to know:
a) am I missing any characters that need to be converted? My first (and only
language) is English, so I'm in the dark
Michael A Nachbaur [EMAIL PROTECTED] writes:
b) is there a better and/or faster way of implementing this? I
don't want searches to bog down (at least too badly) as a result of
this.
Use to_ascii(text),
masm=# select to_ascii('áéíóú');
to_ascii
--
aeiou
(1 row)
Regards,
Manuel.
On Thursday 25 September 2003 05:06 pm, Manuel Sugawara wrote:
Michael A Nachbaur [EMAIL PROTECTED] writes:
b) is there a better and/or faster way of implementing this? I
don't want searches to bog down (at least too badly) as a result of
this.
Use to_ascii(text),
[snip]
D'oh! I guess
I am looking for a way to convert an interval into a number of days (
integer);
In sybase I would use :
days(today()-r_expire)
where r_expire is the timestamp I am comparing against.
How do we do this in postgres?
date_trunc(today()-r_expire) does not seem to do it
select extract(epoch
21 matches
Mail list logo