Tom Lane [EMAIL PROTECTED] writes:
And it's been looked at a few times, and rejected as being far too
bug-prone. The number of ways to screw up by using physical column
number where you should have used logical, or vice versa, is daunting.
One way to make sure there are no such bugs would be
pg_autodoc is nice and open source
Generates HTML, DIA, and other formats
Best Wishes,
Chris Travers
Metatron Technology Consulting
Dann Corbit wrote:
I use ER/Win for that. There are some other tools too. Search the
archives.
-Original Message-
From: [EMAIL PROTECTED]
Problem is: to offer such a thing with a straight face, we'd have to
confine ourselves to an Oracle-subset version of SQL. For instance,
lose the ability to distinguish empty-string from NULL.
I wasn't saying we write it - let Oracle do it :D
Chris
---(end of
google forpostgresql_autodoc-1.21
On 10/18/05, Dann Corbit [EMAIL PROTECTED] wrote:
I use ER/Win for that.There are some other tools too.Search thearchives. -Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general- [EMAIL PROTECTED]
] On Behalf Of Bruno Cochofel Sent: Tuesday,
On Wed, 2005-12-10 at 18:02 -0400, Bill Bartlett wrote:
[snipped]
May not be the best choice on Windows for production use, though for
development, it should be adequate.
Are there known issues with the Windows version for production use, or
is this simply because of the relative
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 grips with FreeBSD.
Anyway, I am having a problem at the moment. Having
Peter Eisentraut wrote:
As the release of PostgreSQL 8.1 draws near, it is once again time to update
the translations of the program messages. To check the status of your
language, check out this web site:
http://developer.postgresql.org/~petere/nlsstatus/
To participate in the
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 types
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
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
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
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
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
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
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
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
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
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
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 pgsql-general@postgresql.org
Subject: Re:
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
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) *
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 fields
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
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
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
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
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
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
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 considering teh
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 considering
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 grips
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 FreeBSD.
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? The
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
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
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 considering
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 create
[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 could
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
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.
I
[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 to PostgreSQL,
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.
Using
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
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
-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
On Wed,
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)---
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 to
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
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 good thing. It'd be a
[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
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
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
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
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-level
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. :)
That is
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 all
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 archives
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, and even
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.
-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, Dann
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 is a
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
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
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
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
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' = '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 string
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 simply
takes the first char of any
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-
-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 PROTECTED]
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
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
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 = 'axy'::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
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
-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:
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 whitespace is
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
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
-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] 'a' ==
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;
1 - 100 of 122 matches
Mail list logo