On Friday 27 September 2002 05:19, Tom Lane wrote:
> Ian Barwick <[EMAIL PROTECTED]> writes:
> > Anyone know what the ANSI standard is? I don`t recall any other
> > database apart from MySQL which default to case-insensitive
> > CHAR or VARCHAR columns.
>
> I believe the spec has a notion of a "co
Ian Barwick <[EMAIL PROTECTED]> writes:
> Anyone know what the ANSI standard is? I don`t recall any other
> database apart from MySQL which default to case-insensitive
> CHAR or VARCHAR columns.
I believe the spec has a notion of a "collation attribute" attached
to character-type columns. You co
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Thu, 26 Sep 2002 [EMAIL PROTECTED] wrote:
>> the query runs for 10 minutes or so, then outputs:
> How much data is that sending? The client library is going to try to
> buffer the entire result set.
And, in fact, this is the typical behavior when i
Peter,
> I'm a newbie to PL/SQL and need help badly. I'm trying to pass my array of
> id's to the function and then loop through until the array is empty. I know
> there must be atleast five things I'm doing wrong.
Simplified example:
CREATE FUNCTION test_array (
INT[] )
RETURNS INT AS
> > > > Are string comparisons in postgresql case sensitive?
>> >
>> >Yes, unless you specify otherwise.
>> >
>> >Are you sure you are using the right database? I can
>> >reproduce similar results, but only like this:
>>
>> You're using MySQL in these examples .. not Postgres :)
>
>Full points for
On Friday 27 September 2002 01:14, Chris wrote:
> >On Thursday 26 September 2002 19:54, Jordan Reiter wrote:
> > > Are string comparisons in postgresql case sensitive?
> >
> >Yes, unless you specify otherwise.
> >
> >Are you sure you are using the right database? I can
> >reproduce similar results
>On Thursday 26 September 2002 19:54, Jordan Reiter wrote:
> > Are string comparisons in postgresql case sensitive?
>
>Yes, unless you specify otherwise.
>
>Are you sure you are using the right database? I can
>reproduce similar results, but only like this:
You're using MySQL in these examples
On Thu, 26 Sep 2002 [EMAIL PROTECTED] wrote:
> I'm having a problem with postgres on HPUX. My version is:
>
> VERSION = 'PostgreSQL 7.2.2 on hppa2.0w-hp-hpux11.11,
> compiled by aCC -Ae'
>
> I'm trying to do a query and it consistently gives the
> followi
On Thursday 26 September 2002 19:54, Jordan Reiter wrote:
> Are string comparisons in postgresql case sensitive?
Yes, unless you specify otherwise.
Are you sure you are using the right database? I can
reproduce similar results, but only like this:
mysql> create temporary table foo (ch char(2),
Not sure if this is a repeat request, sorry if you receive it twice.
Thanks,
Bill Jones
Systems Architect
Middleware Services
Wells Fargo Services Company
Office --415.222.5226
PCS -- 415.254.3831 ([EMAIL PROTECTED])
Views expressed are mine. Only in unusual circumstances are they shared by
my
All,
I'm a newbie to PL/SQL and need help badly. I'm trying to pass my array of
id's to the function and then loop through until the array is empty. I know
there must be atleast five things I'm doing wrong.
Please help!
Cheers,
-p
Call to Procedure and Array:
$myArray = array(15, 6, 23);
se
On Thu, 26 Sep 2002, Jordan Reiter wrote:
> Are string comparisons in postgresql case sensitive?
Yes, AFAIK.
I disagree with your comments and recommendations posted at
http://www.postgresql.org/idocs/index.php?datatype-character.html because
my testing shows that varying text and fixed test co
On Thu, 26 Sep 2002, Andrew Perrin wrote:
> No, I don't think it's supposed to be case-sensitive. In any case, whether
> it's supposed to be or not, it certainly isn't in practice.
AFAIK, they are case sensitive by design. It is the right thing to do.
---(end of broadca
Hi Dmitry,
Got it working
i made a small change.
On Friday 27 September 2002 00:47, you wrote:
> I think this should work:
>
> alter table mytable owner to postgres;
> grant all on my table to public;
instead of
> revoke delete on my table from public;
i did :
revoke delete on my table
I think this should work:
alter table mytable owner to postgres;
grant all on my table to public;
revoke delete on my table from public;
I hope, it helps...
Dima
Rajesh Kumar Mallah. wrote:
> Hi ,
>
> I have a created a database and a table in it,
>
> I want to prevent "DELETES" on the table
First of all, try replacing the username/foldername indexes on operator_messages with
a single combined
index on, say (username,foldername)...
It is still not clear to me why it decides not to use one of those indexes you have
(it would be less efficient than a
combined index, but still better t
Hi Robert,
I will be obliged to receive the "real" code , if its
feasible for you. I am not used RULEs before.
regds
mallah.
On Friday 27 September 2002 00:39, Robert Treat wrote:
> In psuedo-code : create rule on mytable on delete return null
>
> Robert Treat
>
> On Thu, 2002-09-26 at 15:00,
Hi Dima,
I currently have only one user in the system
its me and superuser postgres.
every thing belongs to me currently.
and the programs connect as me.
if make transfer the database ownership to postgres
will all the tables also get transfered to him?
it that case all programs will stop
In psuedo-code : create rule on mytable on delete return null
Robert Treat
On Thu, 2002-09-26 at 15:00, Rajesh Kumar Mallah. wrote:
> Hi ,
>
> I have a created a database and a table in it,
>
> I want to prevent "DELETES" on the table in this
> database by everyone except superuser postgres.
>
> I have a created a database and a table in it,
>
> I want to prevent "DELETES" on the table in this
> database by everyone except superuser postgres.
> even by me (the creator of this database and table)
make superuser the database owner & grant the rights needed to the users
---
Hi ,
I have a created a database and a table in it,
I want to prevent "DELETES" on the table in this
database by everyone except superuser postgres.
even by me (the creator of this database and table)
I have tried in many ways (ALTER TABLE REVOKE DELETE .. etc etc)
but i always end up with h
No, I don't think it's supposed to be case-sensitive. In any case, whether
it's supposed to be or not, it certainly isn't in practice.
Solutions include:
SELECT *
FROM People
WHERE lower(first_name)='jordan';
and:
SELECT *
FROM People
WHERE first_name ~* 'Jordan';
ap
Are string comparisons in postgresql case sensitive?
I keep on having this response:
SELECT *
FROM People
WHERE first_name='jordan'
Result: 0 records
SELECT *
FROM People
WHERE first_name='Jordan'
Result: 1 record
I though that string matching in SQL was case-insensitive. Isn't this correct?
--
Jordan Reiter mailto:[EMAIL PROTECTED]
Breezing.com http://breezing.com
1106 West Main St phone:434.295.2050
Charlottesville, VA 22903 fax:603.843.6931
---(end of broadcast)-
Hi,
In case you doing all this to replicate tables
conside contrib/dbmirror it does it fairly elegantly.
regds
mallah.
On Friday 20 September 2002 13:55, wit wrote:
> Hello,
>
> I have a question about trigger. I have tables with the following
> structure:
>
> create table A (
>e_codeA char
Does any one know what is the reason not to put this logic into date_trunc () function?
It seems to work with pretty much *any* unit imaginable, *except* for 'week'...
Dima
Bruno Wolff III wrote:
> On Thu, Sep 26, 2002 at 11:55:48 -0400,
> Jean-Luc Lachance <[EMAIL PROTECTED]> wrote:
>
>>How
On Thu, Sep 26, 2002 at 11:55:48 -0400,
Jean-Luc Lachance <[EMAIL PROTECTED]> wrote:
> How about:
>
> select now() - date_part( 'DOW', now()) as starts_on,
> now() -date_part( 'DOW', now()) + 6 as ends_on;
That won't work in 7.3.
The following works in both 7.2 and 7.3:
area=> select curre
Unfortunately it is Windows based. The emacs mode for SQL is pretty
primitive too. Oh well - maybe I'll write one someday.
Thanks,
Andy
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of Nort
How about:
select now() - date_part( 'DOW', now()) as starts_on,
now() -date_part( 'DOW', now()) + 6 as ends_on;
"John Sebastian N. Mayordomo" wrote:
>
> How do I get the start and end date of the present week?
> Is this possible?
>
> For example this week
> Start = Sept. 22
> End = Sept
On Thu, Sep 26, 2002 at 18:56:46 +0800,
"John Sebastian N. Mayordomo" <[EMAIL PROTECTED]> wrote:
>
>
> How do I get the start and end date of the present week?
> Is this possible?
>
> For example this week
> Start = Sept. 22
> End = Sept. 28
The following advice will work on 7.3. For 7.2.
How do I get the start and end date of the present week?
Is this possible?
For example this week
Start = Sept. 22
End = Sept. 28
Thank you very much.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi:
Attached to the e-mail is the body of the query and
the result of the EXPLAIN (Sorry for not placing the
query and EXPLAIN in the e-mail body . The query is
rather complicated and the EXPLAIN result is rather
long ).
The file demo.out.3 is the result of the EXPLAIN
The file demo
32 matches
Mail list logo
