On Tue, 2005-10-18 at 15:23 +0200, nadjat ladjrab wrote:
> bonjour:
>
> nous sommes des étudiants de fin d'études 5éme année informatique
> ingénieurs , nous voulons avoir des cours concernant les bases de
> données avancées précisemment modéle relationnel étendu et la
> manipulation des type
Onyx wrote:
Hello Everyone,
Does anyone know if PostgreSQL supports running on dual processors, and
will efficiently utilize the dual processors for performance? More
specifically, will PostgreSQL utilize the dual processor performance of
using dual-core AMD chips? Any information would be h
I am having difficulty compiling postgresql8.0.3 using ports on
FreeBSD. I
need to use either MIT or HEIMDAL KRB5 to 'make' it.
How do I do it? (I am a newbie with make). make --DWITH_MIT_KRB5 etc
haven't
worked out.
With many of the ports it's good to read the "Makefile" which is in
directo
Hi Tony,
It is a while since I have worked with Delphi so as soon as I get the
time I will re-evaluate, which I have been meaning to do given that I
have seen some really great DB tools for Delphi that I would like to try.
I agree that when access gets used to create lots of small Databases
eac
On 19.10.2005 08:23, [EMAIL PROTECTED] wrote:
I excluded
/cube and /mysql from the MakeFile (cube seemed to be failing and why
would I want mysql stuff on PostgreSQL?). I then did a gmake install. All
contribs seemed to install fine. I reran the restore on a clean DB and
most of the errors went a
Hakan Kocaman wrote:
Hello Folks,
first i want to apologize for my bad english :~)
we got here apparntly 2 issues with the above mentioned functionality:
1. I want to use functions with composite types as parameters,
which is no deal on our current production server(postgres 7.4.3)
but
On Wed, Oct 19, 2005 at 12:32:36AM -0700, William Yu wrote:
> Expect to need to upgrade to later Linux cores though. Previous kernel
> on this server was 2.6.9+ (FC3 64-bit) -- promptly kernel panic'd upon
> install of the DCs. FC3 installer did the same thing. Went to FC4
> (2.6.11+) and it has
On Wed, 19 Oct 2005, Christopher Kings-Lynne wrote:
If there smart enough to be buying innobase these days, you can bet that
by now they have this stuff all straightened out.
No, that doesn't seem to follow ... if Oracle are spending their
resources to attack MySQL rather than us, the conclu
Onyx schreef:
When i look at pgadmin:
an anoying feature: it closes when u do something illegal, instead of
saying: u don't have the rights to do this.
Which version of PgAdmin were you using? III? Or II? In my findings, I
have had similiar problems to what you have been experiencing
On Wed, Oct 19, 2005 at 10:55:22AM +0800, Christopher Kings-Lynne wrote:
> With no disrespect to PostgreSQL, MySQL has 100x our downloads and
> installations...
Just for the hell of it I looked at the popcon stats for debian
installs (see below). It tells me the following:
- Something like half
On Wed, 2005-10-19 at 12:51 +0200, Martijn van Oosterhout wrote:
> Just for the hell of it I looked at the popcon stats for debian
> installs (see below). It tells me the following:
>
> - Something like half the people who install mysql-server (any version)
> never use it. People who install Postg
Hello Richard,
thanks for your response.
Your testcase does indeed make no problems.
I stripped down my case to be as simple as yours
and it worked too.
Now i try to put the things in it, that are usefull
for me (Validation in the update-function and Conversion
in the view).
I hope (or better
How can I make a global table (like pg_users, pg_shaddow) ?
Thx,
Marius
Tom Lane wrote:
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
Strangely a pgsql to oracle exporter is a good thing. It'd be a great
feature of PostgreSQL. Imagine how many people would start on
PostgreSQL if they KNEW that one day they could easily move to Oracle if
they needed to.
On Tue, 18 Oct 2005, Onyx wrote:
> Hello Everyone,
> Does anyone know if PostgreSQL supports running on dual processors, and will
> efficiently utilize the dual processors for performance? More specifically,
> will PostgreSQL utilize the dual processor performance of using dual-core
> AMD chips
how can i make a global table (like pg_users,
pg_shaddow) ?
Thx,
Marius
In my Pentium 4 box 2GHz with 256 MB of RAM I run a pg server 8.0.3
under netbsd 2.0.2 in which among other tables there's a "huge" table
letture02 made of 657,000 records and 98 numerical columns.
Using psql
and the "heavy" view letture24btnondom (see below) I face the following
fatal error:
I am getting division by zero on a calculated field ( sum(sales) is 0 )
and I can't find a way around this. I figured out you can't use an
aggregate in a where, and using having the parser must (obviously)
evaluate the select fields before considering teh having clause.
Does anyone have a way
Hi all
Does anybody know how I could create a database function that accepts
an INET parameter and reverse-lookups the hostname via DNS PTR lookup?
Something like the dnsname command line utility in the djbdns package. I
need this function for analyzing firewall logs stored in the database
with ul
I am using PHP as the client. The result is not on a webpage but is
downloaded to a PC.
So, I should test the PHP-encoding first.
Thank you I will do that.
From: Michael Glaesemann <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: pgsql-general
Subject: Re: [GENERAL] Wrong charset?
Date: Wed,
> > No, that doesn't seem to follow ... if Oracle are spending their
> > resources to attack MySQL rather than us, the conclusion would be
that
> > they are clearly still more informed by "the buzz" than technical
merit.
>
> With no disrespect to PostgreSQL, MySQL has 100x our downloads and
> inst
You could use a CASE statement...
select
type,
sum(sales),
sum(cost),
CASE WHEN sum(sales) <> 0 THEN (sum(sales) * sum(cost) / sum(sales)) *
100 ELSE 0 END
from test
group by 1
However, I guess that your example is just not what you really use as
sum(sales) * sum(cos
On 10/19/05 8:26 AM, "Tim Nelson" <[EMAIL PROTECTED]> wrote:
> I am getting division by zero on a calculated field ( sum(sales) is 0 )
> and I can't find a way around this. I figured out you can't use an
> aggregate in a where, and using having the parser must (obviously)
> evaluate the select fi
Tim Nelson wrote:
I am getting division by zero on a calculated field ( sum(sales) is 0 )
It's a two-stage process, so you'll want a sub-query. Something like:
SELECT
type,
tot_sales,
tot_cost
((tot_sales * tot_cost / tot_sales) * 100) AS percent
FROM
(
SELECT
type, sum(sales) AS tot
Marius Cornea wrote:
How can I make a global table (like pg_users, pg_shaddow) ?
You can't afaik. There are three things you can do though.
1. Anything you put into pg_template1 gets created in each new database
(unless you choose a different template when creating).
2. The dblink() module in
Marcel Gsteiger wrote:
Hi all
Does anybody know how I could create a database function that accepts
an INET parameter and reverse-lookups the hostname via DNS PTR lookup?
Something like the dnsname command line utility in the djbdns package. I
need this function for analyzing firewall logs store
am 19.10.2005, um 14:36:46 +0200 mailte Marcel Gsteiger folgendes:
> Hi all
>
> Does anybody know how I could create a database function that accepts
> an INET parameter and reverse-lookups the hostname via DNS PTR lookup?
> Something like the dnsname command line utility in the djbdns package. I
give this a try if you don't mind using plperlu. This was tested with
Postgresql 8.0.3
create or replace function gethostbyaddr(inet) returns text
as
$$
use strict;
use Socket;
my $inet = $_[0];
my $iaddr=inet_aton($inet);
my $name = gethostbyaddr($iaddr,AF_INET);
return $name;
$$
language plpe
Vittorio wrote:
In my Pentium 4 box 2GHz with 256 MB of RAM I run a pg server 8.0.3
under netbsd 2.0.2 in which among other tables there's a "huge" table
letture02 made of 657,000 records and 98 numerical columns.
Using psql
and the "heavy" view letture24btnondom (see below) I face the follo
On Oct 19, 2005, at 21:26 , Tim Nelson wrote:
I am getting division by zero on a calculated field ( sum(sales) is
0 ) and I can't find a way around this. I figured out you can't
use an aggregate in a where, and using having the parser must
(obviously) evaluate the select fields before con
Tim Nelson <[EMAIL PROTECTED]> writes:
> I am getting division by zero on a calculated field ( sum(sales) is
> 0 ) and I can't find a way around this. I figured out you can't use
> an aggregate in a where, and using having the parser must
> (obviously) evaluate the select fields before considerin
Tim Nelson <[EMAIL PROTECTED]> schrieb:
> I am getting division by zero on a calculated field ( sum(sales) is 0 ) and
> I can't find a way around this. I figured out you can't use an aggregate
> in a where, and using having the parser must (obviously) evaluate the
> select fields before consid
On Wed, 2005-10-19 at 08:23 +0200, [EMAIL PROTECTED] wrote:
> Hi
>
> I am very new to FreeBSD (Windows Background), but am busy trying to
> implement a PostgreSQL database that I have running in the Windows
> environemtn on FreeBSD. Naturally, most of my problems so far have been
> geeting to grip
Hi Sven
Thanks for the info. This is a great help.
One question:
> On Wed, 2005-10-19 at 08:23 +0200, [EMAIL PROTECTED] wrote:
>> Hi
>>
>> I am very new to FreeBSD (Windows Background), but am busy trying to
>> implement a PostgreSQL database that I have running in the Windows
>> environemtn on F
Hi Sven
Thanks for the help. This looks like the kind of info I needed.
One question:
You suggest that I use : pkg_add -r postgresql80-server. If this requires
postgresql80-client, will it automatically download it and install? The
docs I have read suggest this, but maybe you can confirm?
Thanks
I think this probably belongs back on -advocacy, so I'm cc:ing there
so we can move it.
On Tue, Oct 18, 2005 at 03:16:23PM -0700, Chris Travers wrote:
> Interesting. So they are willing to appear ill-informed in public but
> better informed in private? To what end? That seems strange to me
On Wed, 2005-10-19 at 15:55 +0200, [EMAIL PROTECTED] wrote:
> Hi Sven
>
> Thanks for the help. This looks like the kind of info I needed.
> One question:
> You suggest that I use : pkg_add -r postgresql80-server. If this requires
> postgresql80-client, will it automatically download it and install
Hi,
I am also interested in helping building Bulgarian translation for
PostgreSQL.
I think that we will not have enough time for 8.1 but maybe for 8.2.
Regards
Lyubomir Rusanov
Ivan Pavlov wrote:
Peter Eisentraut wrote:
As the release of PostgreSQL 8.1 draws near, it is once aga
Richard Huxton wrote:
Tim Nelson wrote:
I am getting division by zero on a calculated field ( sum(sales) is 0 )
It's a two-stage process, so you'll want a sub-query. Something like: ...
Thanks. That's a cool addition to my bag of tricks.
---(end of broadcast)-
Tim Nelson <[EMAIL PROTECTED]> writes:
> I am getting division by zero on a calculated field ( sum(sales) is 0 )
> and I can't find a way around this. I figured out you can't use an
> aggregate in a where, and using having the parser must (obviously)
> evaluate the select fields before consider
You can also reverse engineer a postgreSQL RDBMS using an ODBC driver and
MicroSloth's Visio.
"Bruno Cochofel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi you all,
>
> His there any SW that can do reverse engineering on postgreSQL
> databases? I need something that can
[EMAIL PROTECTED] wrote on 10/19/2005 12:35:25 AM:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> > Strangely a pgsql to oracle exporter is a good thing. It'd be a great
> > feature of PostgreSQL. Imagine how many people would start on
> > PostgreSQL if they KNEW that one day they cou
Hi all,
Postgres version: 8.0.3
I wonder if I understood correctly what log_min_duration_statement
does... I set it to 2000, and the result is that all queries running
more than 2 seconds on _local_ connections are logged, but long running
queries on remote connections are not logged. Is this som
Csaba Nagy <[EMAIL PROTECTED]> writes:
> I wonder if I understood correctly what log_min_duration_statement
> does... I set it to 2000, and the result is that all queries running
> more than 2 seconds on _local_ connections are logged, but long running
> queries on remote connections are not logged
[EMAIL PROTECTED] ("Merlin Moncure") writes:
>> > No, that doesn't seem to follow ... if Oracle are spending their
>> > resources to attack MySQL rather than us, the conclusion would be
>> > that they are clearly still more informed by "the buzz" than
>> > technical merit.
>>
>> With no disrespect
Alle 15:07, mercoledì 19 ottobre 2005, Richard Huxton ha scritto:
> Vittorio wrote:
> > In my Pentium 4 box 2GHz with 256 MB of RAM I run a pg server 8.0.3
> > under netbsd 2.0.2 in which among other tables there's a "huge" table
> > letture02 made of 657,000 records and 98 numerical columns.
> >
Well, I'm completely sure that long running queries from local
connections are logged, as I can see them in the log file. Quick queries
are not logged even for local connections, I tested that too...
And I'm also sure that I do have long running queries on remote
connections, our application logged
On Wed, 19 Oct 2005, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 10/19/2005 12:35:25 AM:
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
Strangely a pgsql to oracle exporter is a good thing. It'd be a great
feature of PostgreSQL. Imagine how many people would start on
PostgreS
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Marc G. Fournier
> Sent: Wednesday, October 19, 2005 9:02 AM
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
>
>
Hi all,
I wonder how fair is the lock allocation of SELECT FOR UPDATE ?
Is it fair, i.e. the first transaction which requested the lock will get
it, or it is possible that new requests are served quicker ?
TIA,
Csaba.
---(end of broadcast)---
TIP
A "PostgreSQL to Oracle converter" might be a really big project.
Having ported an application from PostgreSQL (7.3) to Oracle 9i, as I
recall, my biggest problems were:
- Quoting issues: the original PostgreSQL application quoted
integer/numeric type, and Oracle will not allow that, so I had t
Mark Rae wrote:
On Wed, Oct 19, 2005 at 12:32:36AM -0700, William Yu wrote:
Expect to need to upgrade to later Linux cores though. Previous kernel
on this server was 2.6.9+ (FC3 64-bit) -- promptly kernel panic'd upon
install of the DCs. FC3 installer did the same thing. Went to FC4
(2.6.11+)
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote on 10/19/2005 01:02:15
PM:
> On Wed, 19 Oct 2005, [EMAIL PROTECTED] wrote:
>
> >
> >
> > [EMAIL PROTECTED] wrote on 10/19/2005 12:35:25 AM:
> >
> >> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> >>> Strangely a pgsql to oracle exporter is a go
[EMAIL PROTECTED] wrote:
> Yep. It is not just limited to empty strings; An all blank string,
> no matter the number of characters, is stored as NULL. And a
I'm no big Oracle fan; I'm trying to convince my company to convert a
major database to PG. But I can't reproduce what you are saying here
From the ANSI/ISO SQL Standard:
"3) The comparison of two character strings is determined as follows:
a) Let CS be the collating sequence indicated in Subclause 4.2.3,
''Rules determining collating sequence usage'', based on the declared
types of the two character strings.
b) If the length in char
Csaba Nagy <[EMAIL PROTECTED]> writes:
> Now the remote connections are coming from Java (the JDBC driver),
Oh, there's your problem. 8.0 doesn't have very good support for
logging the extended-query protocol, which is what recent versions
of the JDBC driver like to use. 8.1 will be better I bel
That's me and my project listed there. Glad to give PG the good press
it deserves, it's the least I could do. It's been a great db for us,
and we're looking forward to 8.1.
And thanks for the help that I received on the mailing list a few months
back that directly impacted this project. It
I need to know if there is a tool that convert oracle procedures and
triggers to plpgsql syntax. Please, can anybody tell me where do i download
it from?, i'll thank you a lot.
Rafael
_
Un amor, una aventura, compañía para un via
This is maybe a really newbie question, but, when I have an
SQL function like that:
$$
Insert into mytable (id, name) values ($1, $2);
$$
What return value suppose to return?
I have a database of e-mail addresses.
I want to select the email addresses which are not valid:
do not contain exactly one @ character,
contain ; > < " ' , characters or spaces etc.
What is the WHERE clause for this ?
Andrus.
---(end of broadcast)---
Csaba Nagy <[EMAIL PROTECTED]> writes:
> I wonder how fair is the lock allocation of SELECT FOR UPDATE ?
> Is it fair, i.e. the first transaction which requested the lock will get
> it, or it is possible that new requests are served quicker ?
8.1 will guarantee first-come-first-served for row-leve
On Wed, Oct 19, 2005 at 09:55:18AM -0700, William Yu wrote:
> Mark Rae wrote:
> >With the newer kernels you should find that a dual core will
> >be giving you about 80% increase over a single core.
>
> I'm not experiencing this problem right now because I have NUMA disabled
> in the BIOS. :)
T
On Wed, 19 Oct 2005, [EMAIL PROTECTED] wrote:
I was referring to trailing blanks, but did not explicitly say it,
though showed it in the examples. I am pretty sure that the SQL
standard says that trailing whitespace is insignificant in string
comparison.
Then we are broken too :)
# select
This might be handy:
http://www.databasejournal.com/img/email_val.sql
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Andrus
> Sent: Wednesday, October 19, 2005 11:12 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Select al
Andrus wrote:
> I have a database of e-mail addresses.
>
> I want to select the email addresses which are not valid:
>
> do not contain exactly one @ character,
> contain ; > < " ' , characters or spaces etc.
>
> What is the WHERE clause for this ?
Please see a long, detailed thread in the arch
On Wed, Oct 19, 2005 at 09:12:16PM +0300, Andrus wrote:
> I want to select the email addresses which are not valid:
>
> do not contain exactly one @ character,
> contain ; > < " ' , characters or spaces etc.
The rules that define a valid email address are more complex than
most people realize, an
Yes, clearly that is the wrong result according to the SQL standard.
Here is a SQL*Server query:
select 1 where 'a' = 'a ' AND 'a' = 'a ' AND 'a ' = 'a '
It returns (correctly): 1
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf
OK, I am not an expert on the SQL standard, but I thought the definition
varied by data type e.g. varchar <> bpchar
Terry
Marc G. Fournier wrote:
On Wed, 19 Oct 2005, [EMAIL PROTECTED] wrote:
I was referring to trailing blanks, but did not explicitly say it,
though showed it in the examples.
I'm CC'ng this over to -hackers ... Tom? Comments?
On Wed, 19 Oct 2005, Dann Corbit wrote:
Yes, clearly that is the wrong result according to the SQL standard.
Here is a SQL*Server query:
select 1 where 'a' = 'a ' AND 'a' = 'a ' AND 'a ' = 'a '
It returns (correctly): 1
-Orig
> -Original Message-
> From: Stephan Szabo [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 19, 2005 12:39 PM
> To: Dann Corbit
> Cc: Marc G. Fournier; [EMAIL PROTECTED]; pgsql-
> [EMAIL PROTECTED]
> Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
>
> On Wed, 19 Oct 2005,
On Wed, 19 Oct 2005, Dann Corbit wrote:
> Yes, clearly that is the wrong result according to the SQL standard.
>
> Here is a SQL*Server query:
> select 1 where 'a' = 'a ' AND 'a' = 'a ' AND 'a ' = 'a '
>
> It returns (correctly): 1
Doesn't that depend on the collating sequence in use, or
Would you want varchar(30) 'Dann Corbit' to compare equal to bpchar(30)
'Dann Corbit'?
I would.
If both are considered character types by the language, then they must
compare that way.
Perhaps there are some nuances that I am not aware of. But that is how
things ought to behave, if I were kin
On Wed, 19 Oct 2005, Dann Corbit wrote:
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 12:39 PM
To: Dann Corbit
Cc: Marc G. Fournier; [EMAIL PROTECTED]; pgsql-
[EMAIL PROTECTED]
Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innoba
Given this part of that same rule applied to the strings:
"b) If the length in characters of X is not equal to the length in
characters of Y, then the shorter string is effectively replaced, for
the purposes of comparison, with a copy of itself that has been extended
to the length of the longer str
On 19 Oct 2005, at 16:05, codeWarrior wrote:
You can also reverse engineer a postgreSQL RDBMS using an ODBC
driver and
MicroSloth's Visio.
"Bruno Cochofel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi you all,
His there any SW that can do reverse engineering on pos
Am Mittwoch, den 19.10.2005, 16:29 -0300 schrieb Marc G. Fournier:
> I'm CC'ng this over to -hackers ... Tom? Comments?
>
> On Wed, 19 Oct 2005, Dann Corbit wrote:
>
> > Yes, clearly that is the wrong result according to the SQL standard.
> >
> > Here is a SQL*Server query:
> > select 1 where 'a
I agree with you, but...
Actually that's not how the compare works usually.
Generally one of the operands is converted to the same datatype as the
other, and THEN the compare is performed.
I expect MS SQL is converting a 'sdas' typeless string to be assumed
CHAR and Postgresql is converting
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Wed, 19 Oct 2005, [EMAIL PROTECTED] wrote:
>
>> I was referring to trailing blanks, but did not explicitly say it,
>> though showed it in the examples. I am pretty sure that the SQL
>> standard says that trailing whitespace is insignificant in s
Tino Wildenhain wrote:
Then we are broken too :)
# select 'a ' = 'a ';
?column?
--
f
(1 row)
>
>
> experiment=# SELECT 'a '::char = 'a '::char;
> ?column?
> --
> t
>
This does't show anything useful, because the ::char casting s
create table foo (col1 varchar(30))
go
create table bar (col1 char(30))
go
insert into foo values ('Danniel ')
go
insert into bar values ('Danniel ')
go
select * from foo,bar where foo.col1=bar.col1
go
Result set:
Danniel Danniel
> -Original Message-
> Fro
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Doug Quale
> Sent: Wednesday, October 19, 2005 1:10 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
>
> "Marc G. Fournier" <[EMAIL PRO
create table fooa (col1 varchar(30))
go
create table bara (col1 varchar(300))
go
insert into fooa values ('Danniel ')
go
insert into bara values ('Danniel ')
go
select * from fooa,bara where fooa.col1=bara.col1
go
Returns:
Danniel Danniel
I think that the issue is:
Does PostgreSQL us
Try this query in Oracle, SQL*Server, DB/2, Informix, etc.:
connxdatasync=# select 1 where cast('a' as varchar(30)) = cast('a ' as
varchar(30));
?column?
--
(0 rows)
I see how you can interpret the SQL Standard to make the above response
a correct one. But is it the response that you wo
"Guy Rouillier" <[EMAIL PROTECTED]> writes:
> Tino Wildenhain wrote:
> >
> > experiment=# SELECT 'a '::char = 'a '::char;
> > ?column?
> > --
> > t
> >
>
> This does't show anything useful, because the ::char casting simply
> takes the first char of any string:
>
> select 'abc'::char
1.The sintax for create table is :
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
{ column_name data_type [ DEFAULT default_expr ] [ column_constraint [
... ] ] ...
What mean the parameter GLOBAL|LOCAL ??
2. in pg_class it is a field "relisshared" how can i use it ?
Hi Dann
Without looking at the internals to see if the 1 column or the other is
being converted to the other columns type before the compare, it really
demonstrates nothing.
It could perhaps be used to help demonstrate that when comparing a
datatype of CHAR to VARCHAR that
MS-SQL converts t
Dann Corbit wrote:
Try this query in Oracle, SQL*Server, DB/2, Informix, etc.:
connxdatasync=# select 1 where cast('a' as varchar(30)) = cast('a ' as
varchar(30));
?column?
--
(0 rows)
I see how you can interpret the SQL Standard to make the above response
a correct one. But is it t
> -Original Message-
> From: Terry Fielder [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 19, 2005 2:05 PM
> To: Dann Corbit
> Cc: Tino Wildenhain; Marc G. Fournier; [EMAIL PROTECTED];
> pgsql-hackers@postgresql.org; pgsql-general@postgresql.org
> Subject: Re: 'a' == 'a ' (Was: RE: [p
Doug Quale wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>
>> On Wed, 19 Oct 2005, [EMAIL PROTECTED] wrote:
>>
>>> I was referring to trailing blanks, but did not explicitly say it,
>>> though showed it in the examples. I am pretty sure that the SQL
>>> standard says that trailing whit
Chris Browne wrote:
[EMAIL PROTECTED] ("Merlin Moncure") writes:
No, that doesn't seem to follow ... if Oracle are spending their
resources to attack MySQL rather than us, the conclusion would be
that they are clearly still more informed by "the buzz" than
technical merit.
With no
This is the salient sentence from the standard (that I've never personnally
thought much about before now).
"If CS has the NO PAD characteristic, then the pad character is an
implementation-dependent character different from any character in the
character set of X and Y that collates less than any
Doesn't NO PAD connect to the collating sequence (CS) rather than the
data type?
ISO/IEC 9075-2:1999 (E) (c)ISO/IEC
4.2 Character strings
A character set is described by a character set descriptor. A character
set descriptor includes:
- The name of the character set.
- The name of the default coll
"Dann Corbit" <[EMAIL PROTECTED]> wrote on 10/19/2005 04:33:23 PM:
> Doesn't NO PAD connect to the collating sequence (CS) rather than the
> data type?
Yep. Back to the mental drawing board.
BTW, the ordering of posts when they come to my mailbox is really weird.
>
> ISO/IEC 9075-2:1999 (E)
Okay, since the standard explicitly says that whether 'a' = 'a ' is a
well-defined characteristic of a character datatype (NO PAD) I'm happy with
both Oracle and PostgreSQL. If you want a certain behavior, choose your
datatypes wisely. Cool. I didn't in a recent port. Uncool. I went from
CHAR(
> -Original Message-
> From: Stephan Szabo [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 19, 2005 2:34 PM
> To: Dann Corbit
> Cc: Terry Fielder; Tino Wildenhain; Marc G. Fournier;
> [EMAIL PROTECTED]; pgsql-hackers@postgresql.org; pgsql-
> [EMAIL PROTECTED]
> Subject: Re: [HACKERS] '
On Wed, 19 Oct 2005, Dann Corbit wrote:
> > -Original Message-
> > From: Terry Fielder [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, October 19, 2005 2:05 PM
> > To: Dann Corbit
> > Cc: Tino Wildenhain; Marc G. Fournier; [EMAIL PROTECTED];
> > pgsql-hackers@postgresql.org; pgsql-general@p
On Wed, Oct 19, 2005 at 02:05:20PM -0700, Dann Corbit wrote:
> > When the compared datatypes are VARCHAR: YES
>
> What is the value of doing that?
>
> I can see plenty of harm and absolutely no return. We are talking about
> blank padding before comparison. Do you really want 'Danniel '
> consi
> -Original Message-
> From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 19, 2005 2:46 PM
> To: Dann Corbit
> Cc: Terry Fielder; Tino Wildenhain; Marc G. Fournier;
> [EMAIL PROTECTED]; pgsql-hackers@postgresql.org; pgsql-
> [EMAIL PROTECTED]
> Subject: Re: 'a
On 10/19/2005 3:46 PM, Dann Corbit wrote:
Would you want varchar(30) 'Dann Corbit' to compare equal to bpchar(30)
'Dann Corbit'?
I would.
wieck=# select 'Jan'::varchar(20) = 'Jan'::char(20);
?column?
--
t
(1 row)
wieck=# select 'Jan'::char(20) = 'Jan'::varchar(20);
?column?
-
On Tue, 2005-18-10 at 22:21 -0500, Tony Caduto wrote:
> From what i understand Postgresql will scale with more cpus, but not in
> the same way as threaded server would.
Threading isn't really relevant. PostgreSQL currently forks a new
process for each client connection, and each process can be s
1 - 100 of 128 matches
Mail list logo
