Relaxin wrote:
Hello
Does anyone understand what is meant by a case-insensitive database.
You could define your own encoding, and use that.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Network Administrator <[EMAIL PROTECTED]> writes:
> ... However it seems to me that right now that this might not be
> possible while the backend is changing between major releases.
> Perhaps once that doesn't fluxate as much it might be feasible to
> create these layer so that it is not too fat.
- Forwarded message from elein <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
Date: Sun, 14 Sep 2003 20:48:22 -0700
From: elein <[EMAIL PROTECTED]>
To: Avi Schwartz <[EMAIL PROTECTED]>
Cc: elein <[EMAIL PROTECTED]>
Subject: Re: [GENERAL] is General Bits Issue # 43 correct?
In-Reply-
Quoting Tom Lane <[EMAIL PROTECTED]>:
> Network Administrator <[EMAIL PROTECTED]> writes:
> > The abstraction I am talking about would be a logical layer that would
> handle
> > disk I/O including the format of that data (lets call this the ADH).
>
> This sounds good in the abstract, but I don't
How to install Cygwin PostgreSQL as NT Services on
Windows 2000.
i have do all procedure in postgresql-7.3.4.README
file but i found error
$ net start postmasterThe postmaster service
is starting.The postmaster service could not be started.
The service did not report an error
Thank you.
Calling from java code, is the same as:
select test(1);
Regards
Joseph
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 9:22 AM
To: Keow Yeong Huat Joseph
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] function call
create
create or replace function test(integer) returns boolean as '
declare
number alias for $1;
begin
if number = 0 then
return false;
else
return true;
end if;
end;' language 'plpgsql';
to call the function you can
SELECT test(1);
or can do
SELECT user_id,
user_name,
Stephan Szabo <[EMAIL PROTECTED]> writes:
> Potentially on some systems it'd be possible to
> generate a case insensitive collation as part of a locale
> and then use such for LC_COLLATE on initdb which would make all
> comparisons of text fields case insensitive.
Another possibility is to create
In this issue the following statement is made:
"In plpgsql, you cannot run a dynamic SELECT statement and be able to
do anything with the selected data. You cannot assign the selected
value to a variable or return the selected value from the function. You
can, however, easily construct INSERT,
On Sun, 2003-09-14 at 14:17, Christopher Browne wrote:
> After a long battle with technology,[EMAIL PROTECTED] (Martin Marques), an
> earthling, wrote:
> > El Dom 14 Sep 2003 12:20, Lincoln Yeoh escribió:
> >> >At 07:16 PM 9/13/2003 -0400, Lamar Owen wrote:
[snip]
> Certainly there are backup syst
On Sat, 13 Sep 2003, Relaxin wrote:
> No, I mean the data.
>
> select * from stocks where symbol = 'AADBX'
> and
> select * from stocks where symbol = 'aadbx'
>
> would bring up the same result set.
Potentially on some systems it'd be possible to
generate a case insensitive collation as part of
Thank you, that was the answer I was look for.
"Stephan Szabo" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> On Sat, 13 Sep 2003, Relaxin wrote:
>
> > No, I mean the data.
> >
> > select * from stocks where symbol = 'AADBX'
> > and
> > select * from stocks where symbol = 'aadbx'
Hello
Does anyone understand what is meant by a case-insensitive database.
Are there some collations that can be changed or is there just no way to
have a true case-insensitive Postgresql database?
Thanks
"Dennis Gearon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Relaxin w
Hi,
Would anyone able to
advise how can I call a function/Stored procedure? what command to
issue?
Thanks.
Best
Regards
___
Joseph
Keow
Hi guys,
just a quick and probably stupid question. When I make a cluster
based on an index on a table, how can I remove it later? Should I
'create' a new one by using the primary key index?
Also, can I have more than 1 cluster on my table? Let me explain ...
can I put for instance the reco
On Sat, 13 Sep 2003, Relaxin wrote:
> Is there a way to make Postgresql case-INSENSITIVE?
Case insensitive in what regard?
That textual comparisons are done case-insensitively in queries?
That object names are determined case-insensitively?
---(end of broadcast)
Relaxin wrote:
No, I mean the data.
select * from stocks where symbol = 'AADBX'
and
select * from stocks where symbol = 'aadbx'
would bring up the same result set.
Look in the manuals, there are SQL functions like:
STRTOLOWER( ); STRTOUPPER() like those in 'C'
Usage:
---
SELECT *
FROM
After a long battle with technology,[EMAIL PROTECTED] (Martin Marques), an earthling,
wrote:
> El Dom 14 Sep 2003 12:20, Lincoln Yeoh escribió:
>> >At 07:16 PM 9/13/2003 -0400, Lamar Owen wrote:
>> >'migration' server. And I really don't want to think about dump/restore
>> >of 100TB (if PostgreSQ
select * from stocks where lower(symbol) = 'aadbx';
or
select * from stocks where symbol ilike =aadbx';
or
select * from stocks where symbol ~* 'aadbx';
HTH
Darren
On Sat, 13 Sep 2003, Relaxin wrote:
> No, I mean the data.
>
> select * from stocks where symbol = 'AADBX'
> and
> select * from st
Is there a way to make Postgresql case-INSENSITIVE?
Thanks
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
No, I mean the data.
select * from stocks where symbol = 'AADBX'
and
select * from stocks where symbol = 'aadbx'
would bring up the same result set.
"Christopher Browne" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Quoth "Relaxin" <[EMAIL PROTECTED]>:
> > Is there a way to make
Quoth "Relaxin" <[EMAIL PROTECTED]>:
> Is there a way to make Postgresql case-INSENSITIVE?
It already is.
portfolio=# select * from stocks limit 1;
symbol | description | exchange
+-+--
AADBX | AADBX | NYSE
(1 row)
portfolio=# sELeCT * FROM STOCKS LIMIT 1;
> A message like this?
> lost synchronization with server, resetting connection
>
Yeah, like that.
I get pissed way too often when people miss simplest things and bug me with
stupid questions, and now it's me.
Sorry guys.
---(end of broadcast)--
Not that my DB is that big.. but if it was and it contained any sort of
financial data (something that you might want to dispute 2 years down
the road) then I would have multiple replicated systems (which I do have
.. but they are MSSQL) and I would also be backing the data up to an
offsite storag
Teodor Sigaev <[EMAIL PROTECTED]> writes:
>> AFAICT tsearch2's incompatibility is in the redefined YY_INPUT macro,
>> which seems of no value for Postgres anyway. Can't we take that out?
> I resolve problem with gm4 with a help of symlink and reorder my PATH. So, it
> compiles but creates core d
El Dom 14 Sep 2003 12:20, Lincoln Yeoh escribió:
> >At 07:16 PM 9/13/2003 -0400, Lamar Owen wrote:
> >'migration' server. And I really don't want to think about dump/restore
> >of 100TB (if PostgreSQL actually stores the image files, which it might).
>
> Hmm. Just curious, do people generally back
Not that I know anything about the internal workings of PG but it seems like a
big part of the issue is the on disk representation of database. I've never had
a problem with the whole dump/restore process and in fact anyone that has been
doing this long enough will remember when that process was g
27 matches
Mail list logo
