[SQL] Inheriting text[] field

Dear Friend, I have the following problem when I try to inherits one table with text[] field into another. I am useing PostgreSQL 7.2.3. I suppose that this is a BUG but I am not sure. Any ides. 10x in advance. Kaloyan test_libvar=# create table temp_a( test_libvar(# name text[] test_libvar(#

Re: [SQL] duplicate table in two databases

Fabio Ferrero wrote: I use postgres 7.2.1 (debian woody) and PHP. I've two databases (foo and bar for example) with the same table (ie. stamps). It's possible with a single query transfer the data from the stamps table in db foo to the stamps table in db bar? You might want to look in the

Re: [SQL] CROSS-TAB query help? I have read it cant be done in one

Theo Galanakis wrote: Does anyone know how to perform a cross-tab query in ONE SQL without having to write a SP? The SQL at the end of this email attempts to display the subquery result-set in a cross-tab format, it does not group the content onto one row as it should in the sample below. SQL is

Re: [SQL] any chance SQL ASSERTIONS will be implemented?

Markus Bertheau wrote: in the course of designing a database schema and ensuring integrity everywhere I have stumbled over a problem that Josh told me ASSERTIONS would solve. Is there any chance ASSERTIONS will be implemented in PostgreSQL? There is a pretty good chance, but there is no

Re: [SQL] Verifying data type

=?ISO-8859-1?Q?Elieser_Le=E3o?= [EMAIL PROTECTED] writes: I need to verify if the data in p_valor is just number or it is a string. What is the best way to do this? In PG 8.0 you can just do it exactly the way your Oracle original does, viz try to cram it into a numeric variable and catch the

Re: [SQL] CROSS-TAB query help? I have read it cant be done in on

Title: RE: [SQL] CROSS-TAB query help? I have read it cant be done in one SQL, pro ve them wrong! Thanks Rickard Max may not work as not all the data is numerical. However I will give the contrib/cross-tab a go! Theo -Original Message- From: Richard Huxton [mailto:[EMAIL