SELECT whatever FROM wherever WHERE lower(yourfield) = 'this';
You can do it with a case inseneitive regex search but they can't use
indexes and can become very slow on large tables..
SELECT whatever FROM wherever WHERE yourfield ~* 'this';
lower() does leak a bit of memory from what I've hear
Can I maintain id in variable such
as:
CREATE FUNCTION function1() RETURNS int4AS ' $var =
select nextval(''shipment_gen''); select $var;'LANGUAGE
'sql'
Andrey
> I just migrated a database from MySQL to postgreSQL and am having trouble
> wit postgres' dates.
> MySQL dealt with dates very well, but i don't see the same sort of
> functionality in postgres.
??
> The database is an archive of imformation, and i would like to do a cron'd
> select for an int
Hello.
I just migrated a database from MySQL to postgreSQL and am having trouble
wit postgres' dates.
MySQL dealt with dates very well, but i don't see the same sort of
functionality in postgres.
The database is an archive of imformation, and i would like to do a cron'd
select for an interval ba
"Gerhard Dieringer" <[EMAIL PROTECTED]> writes:
> It's a known bug of plpgsql that if one arg is NULL, all other args
> are also assumed to be NULL. I think (hope) this will be fixed in a
> future version.
7.1. It is already fixed in current development sources.
BTW it's not actually plpgsql's
> I suppose you can use view for your need. For example:
>
...
> Unfortunately this way suits for select only, not for 'insert into b'
> and 'update b' statement.
>
Except that you can use rules to update/insert data into tables when an
insert/update is done on the view. See the docs for detai
On Wed, Jun 28, 2000 at 03:00:04AM -0400, Tom Lane wrote:
> Hash joins don't have anything to do with hash indexes.
> A hash join is a join that makes use of a temporary hashtable
> built on-the-fly *in memory* for that join.
Oh, I see.
> The planner could choose to use an indexscan on a hash i
Hi All,
I am trying to get a table description via
the web. I have tried using desc tablename but although the desc
command appears to be a reserved word, it doesn't appear to be
supported.
Does anyone know how I can extract the
table description (column names)?
Thanks in advance
Davi
> "EK" == Emils Klotins <[EMAIL PROTECTED]> writes:
EK> Hello,
EK> I have a table that has to have several fields with different names,
EK> but equal content. Sounds stupid, but it is because I have 2
EK> different programs querying the same table for user information and
EK> each of
When I call the following plpgsql function with the last two parameters
as Null, the first parameter loses it's value:
ma=> select createFund('fred', null, null);
createfund
(1 row)
However it works fine when I give values to the last two params:
ma=>
Greetings,
I have a database that will be quite large that must be backed up nightly.
I would like to use pg_dump; however, the problem is that we store binary
data as well. Is there a way to backup this up without having to write a
program to do it?
Thanks,
Brian
I need a SQL stored procedure to return arrays. as OUT parameters in
If i declare the array as a "table", then
i cannot do table[i] := some_value. If i declare it as a VARRAY. then i
need to
initialialize all my VARRAY elements using a costructor which is painful
( a simple
for loop does not do i
On Wed, Jun 28, 2000 at 10:56:17AM -0400, Tom Lane wrote:
> Ang Chin Han <[EMAIL PROTECTED]> writes:
> If it was like that then a hash index wouldn't have been applicable
> anyway; hashes are only good for strict equality checks. If you want
> something that can do ordering checks you need a btre
Where can I get more information about programming in
SPI.
(more than in PostgreSQL documentation).
Thanks for any help
Adam
15 matches
Mail list logo
