On Wed, 15 Jan 2003, Tatsuo Ishii wrote:
> Does anybody know:
>
> select 1.0 union select 1;
> or
> select 1 union select 1.0;
>
> should return 1 or 1.0?
Hmm, I think (but am not sure) that the spec bit
in SQL92 that addresses this is 9.3
Set operation result data types based on the
text in 7.1
Seems fine to me - the second select being cast to the type of the first
select.
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tatsuo Ishii
> Sent: Wednesday, 15 January 2003 12:04 PM
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] UNION result
I think the cause is that multi-type UNION queries use the first query
for casting the other parts of the UNION. In the old days we would just
reject the query because the UNION columns are of different types.
---
Tatsuo Is
Does anybody know:
select 1.0 union select 1;
or
select 1 union select 1.0;
should return 1 or 1.0?
I see below on my Linux box:
test=# select 1 union select 1.0;
?column?
--
1
(1 row)
test=# select 1.0 union select 1;
?column?
--
1.0
(1 row)
This seems a lit
Hi guys,
Have been discussing what it would take to write an "SDBC" driver for
connecting StarOffice/OpenOffice to PostgreSQL with Frank Schönheit, a
senior member of the Sun StarOffice/OpenOffice DBA team, and a few
senior members of the OpenOffice project.
SDBC is based largely on ODBC, so i
We have roles?
> -Original Message-
> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 15 January 2003 1:16 AM
> To: Christopher Kings-Lynne
> Cc: Hackers
> Subject: Re: [HACKERS] copying perms to another user
>
>
> Christopher Kings-Lynne writes:
>
> > Often I need
On Tue, 2003-01-14 at 20:55, John Liu wrote:
> createlang plpgsql template1
> ERROR: stat failed on file '$libdir/plpgsql': No such file or directory
> createlang: language installation failed
>
> is the above error normal in 7.3.1 on linux?
I find I'm getting the same.
This will happen if th
Hi guys,
Have created a Solaris 8 Intel package for PostgreSQL 7.3.1, but don't
have any SPARC boxes here any more.
Does anyone have a SPARC box handy that would be available for compiling
PostgreSQL 7.3.1 on? It would need to be Solaris 8 (or maybe 9), and
have things like gcc 2.95.x and sim
I've been following this thread, and I thought this might be a good
place and time to throw in a few additional feature requests.
What about expanding the history capabilities of psql's history command
(\s) to include something more bash/tcsh-like? For example:
!insert
-- execute the
Seems it was the removal of an include in this commit:
revision 1.145
date: 2003/01/06 09:58:23; author: petere; state: Exp; lines: +1 -2
Fix for systems that don't have INET_ADDRSTRLEN.
netinet/in.h re-added to include list.
--
On Tue, 2003-01-14 at 17:11, Bruce Momjian wrote:
> Any idea what it needs? What is in inet.h at that line, and where is it
> defined? I see sys/socket.h included. Does sys/types.h help?
>
>
> ---
>
> Rod Taylor wrote:
>
Thats the first time I've managed to add the attachment and forget the
message.
inet.h attached in previous email.
On Tue, 2003-01-14 at 17:11, Bruce Momjian wrote:
> Any idea what it needs? What is in inet.h at that line, and where is it
> defined? I see sys/socket.h included. Does sys/types
Any idea what it needs? What is in inet.h at that line, and where is it
defined? I see sys/socket.h included. Does sys/types.h help?
---
Rod Taylor wrote:
-- Start of PGP signed section.
> It appears that FreeBSD doesn't
It appears that FreeBSD doesn't approve of the use of inet.h in this
fashion. Probably related to the IPV6 changes.
On FreeBSD 4.7:
bash-2.05b$ make install > /dev/null
In file included from pqcomm.c:75:
/usr/include/arpa/inet.h:89: warning: parameter has incomplete type
/usr/include/arpa/inet.h
createlang plpgsql template1
ERROR: stat failed on file '$libdir/plpgsql': No such file or directory
createlang: language installation failed
is the above error normal in 7.3.1 on linux?
thanks.
johnl
---(end of broadcast)---
TIP 4: Don't 'kill
From: "Rod Taylor" <[EMAIL PROTECTED]>
>> While I haven't thought about it very hard, it seems to me that a role
>> might be equivalent or nearly so to a group. If so, we might be able
>> to support roles with little more than some syntactic-sugar work ...
>A few other changes, like allowing own
> While I haven't thought about it very hard, it seems to me that a role
> might be equivalent or nearly so to a group. If so, we might be able
> to support roles with little more than some syntactic-sugar work ...
A few other changes, like allowing ownership of an object to be a group
(role) ra
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> On Tue, Jan 14, 2003 at 12:23:59PM +0800, Christopher Kings-Lynne wrote:
> "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> No, I mean that we don't drop the user. You go:
> ALTER USER chriskl COPY PERMISSIONS FROM blah;
> In this scenario,
On Tue, Jan 14, 2003 at 12:23:59PM +0800, Christopher Kings-Lynne wrote:
> > "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> > > No, I mean that we don't drop the user. You go:
> > > ALTER USER chriskl COPY PERMISSIONS FROM blah;
> >
> > That seems cleaner to me than the DROP thingy.
> >
>
Christopher Kings-Lynne writes:
> Often I need to remove a user and cede their permissions to someone else.
If this happens to you a lot, the solution is to implement roles, grant
privileges to a role, grant the role to a user, and when you remove the
user you grant the role to someone else.
--
On Tue, Jan 14, 2003 at 10:31:14AM -0500, Tom Lane wrote:
> deadlock". How do people feel about reporting the detected cycle as
> a series of NOTICE messages? It would look pretty similar to the
Yes, please!!
A
--
Andrew Sullivan 204-4141 Yonge Street
Liberty RM
On Tue, 2003-01-14 at 15:47, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Will information_schema be strictly SQL99 or will it also have
> > PostgreSQL specific views/fields ?
>
> If it's not strictly conformant to the spec, I see no value in it at
> all.
I mean that it could
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Will information_schema be strictly SQL99 or will it also have
> PostgreSQL specific views/fields ?
If it's not strictly conformant to the spec, I see no value in it at
all. We already have plenty of ability to query the catalogs via
non-standard querie
"Orr, Steve" <[EMAIL PROTECTED]> writes:
> I suspect table locks but are there any database level tracing
> tools to show the SQL? Will the trace_locks and debug_deadlocks parameters
> help and how do I use them?
I do not think those will help you; they are low-level debugging aids
and are probabl
On Tue, 2003-01-14 at 01:39, Christopher Kings-Lynne wrote:
> What about querying the information_schema?
Will information_schema be strictly SQL99 or will it also have
PostgreSQL specific views/fields ?
--
Hannu Krosing <[EMAIL PROTECTED]>
---(end of broadcast)-
> -Original Message-
> From: Robert Treat [mailto:[EMAIL PROTECTED]]
> Sent: 13 January 2003 22:01
> To: Greg Copeland
> Cc: Dave Page; [EMAIL PROTECTED]; PostgresSQLHackers Mailing List
> Subject: Re: [HACKERS] \d type queries - why not views in
> system catalog?!?
>
>
> You have to
26 matches
Mail list logo
