Re: [SQL] How can I retrieve an info about function arguments ?

2002-10-25 Thread Bhuvan A
> I need to retreive full set of info about argument and return types (for > variable length too). test_db=>\df+ my_func will serve your need :( > How I can get it from system catalog ? pg_proc.pronargs-- count of arguments pg_proc.proargtypes -- oid(s) of pg_type for appropriate arguments r

Re: [SQL] Foreign character struggles

2002-10-25 Thread Tim Perdue
On Fri, Oct 25, 2002 at 12:24:43PM -0400, Tom Lane wrote: > If you skipped enable-locale then you are outta luck. The fact that > there is a connection between "a" and "accented a" is purely a locale > issue. What I meant was, if I recompile --enable-locale and install over the current builds, I

Re: [SQL] Foreign character struggles

2002-10-25 Thread Tom Lane
Tim Perdue <[EMAIL PROTECTED]> writes: > I skipped --enable-locale because I feared I would have to dump/restore > all my databases and require re-testing the application. Is that unfounded? If you skipped enable-locale then you are outta luck. The fact that there is a connection between "a" and

Re: [SQL] Foreign character struggles

2002-10-25 Thread Tim Perdue
On Fri, Oct 25, 2002 at 10:37:59AM -0400, Tom Lane wrote: > Tim Perdue <[EMAIL PROTECTED]> writes: > > I compiled postgres with --enable-multibyte and --enable-recode, and it > > doesn't appear to help with my problem. > > I think this is a locale issue, not a character set issue. You > definitel

Re: [SQL] grouping and first()

2002-10-25 Thread Chad Thompson
select first(a) from ta order by a in access, is equivilent to select a from ta order by a limit 1 Thanks Chad P.S. Note that access will always return the same value if you exclude the order by, this is not necessarily true with postgresql or any real RDBS. - Original Message - From:

Re: [SQL] Foreign character struggles

2002-10-25 Thread Tom Lane
Roberto Mello <[EMAIL PROTECTED]> writes: > Where is the procedure for working with i18n'd characters described in the > documentation? I'm looking for something that mentions the specifics of > locale interaction and all that. Offhand I can't think of any section that addresses that topic specif

Re: [SQL] Foreign character struggles

2002-10-25 Thread Roberto Mello
On Fri, Oct 25, 2002 at 10:37:59AM -0400, Tom Lane wrote: > > I think this is a locale issue, not a character set issue. You > definitely need --enable-locale, but I doubt you need either of the > above (unless you need to deal with Unicode or Far-Eastern languages). Where is the procedure for w

Re: [SQL] Foreign character struggles

2002-10-25 Thread Tom Lane
Tim Perdue <[EMAIL PROTECTED]> writes: > I compiled postgres with --enable-multibyte and --enable-recode, and it > doesn't appear to help with my problem. I think this is a locale issue, not a character set issue. You definitely need --enable-locale, but I doubt you need either of the above (unle

[SQL] Foreign character struggles

2002-10-25 Thread Tim Perdue
I compiled postgres with --enable-multibyte and --enable-recode, and it doesn't appear to help with my problem. I have a database which contains "foreign" characters in city names, like "São Paulo" (Sao Paulo). If an end-user types plain-english Sao Paulo, I want the database to pull up "São Pau

Re: [SQL] Upper / lower cases on table and column names

2002-10-25 Thread Stephan Szabo
On Fri, 25 Oct 2002, Reiner Dassing wrote: > I was trying to adopt a database application to PostgreSQL. > (It is written for MySQL and Oracle using perl) > > During this process I recognized the phenomena that upper case letters > of table names and column names are not preserved > in PostgreSQL.

Re: [SQL] Upper / lower cases on table and column names

2002-10-25 Thread Achilleus Mantzios
On Fri, 25 Oct 2002, Reiner Dassing wrote: > (PostgreSQL) 7.1.1: > > Hello all! > > I was trying to adopt a database application to PostgreSQL. > (It is written for MySQL and Oracle using perl) > > During this process I recognized the phenomena that upper case letters > of table names and column n

[SQL] Upper / lower cases on table and column names

2002-10-25 Thread Reiner Dassing
(PostgreSQL) 7.1.1: Hello all! I was trying to adopt a database application to PostgreSQL. (It is written for MySQL and Oracle using perl) During this process I recognized the phenomena that upper case letters of table names and column names are not preserved in PostgreSQL. Is this a "featue" of

Re: [SQL] from postgres to oracle

2002-10-25 Thread Thomas Good
On Thu, 24 Oct 2002, Carlos Sousa wrote: > can some one tell how to transfer the contents from a postgres database into > a oracle database Carlos, I use pg_dump to create full CREATE strings, with no double quotes. pg_dump -s -n -D -x dbname > dbname.sql Then I use pg_dump to create full I

[SQL] How can I retrieve an info about function arguments ?

2002-10-25 Thread Zuev Dmitry
Hello All Consider a function: create function f(varchar(10), decimal(10,1)) returns integer as 'select 1;' language sql; I need to retreive full set of info about argument and return types (for variable length too). How I can get it from system catalog ? For tables columns I can gen an info from p

Re: [SQL] Multiple Databases

2002-10-25 Thread peter
thanks for your help guys. Peter "Joe Conway" <[EMAIL PROTECTED]> wrote in message news:3DB6D01C.9000601@;joeconway.com... > Josh Berkus wrote: > >>Is it possible to create a view using tables from two different > >>postgresql > >>servers? > > > > No. > > > > It isn't possible with plain old SQL

[SQL] grouping and first()

2002-10-25 Thread peter
Hi, just wondering if anyone can tell me what replaces the first function in access. Thanks PEter ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] if exists (select * from ...

2002-10-25 Thread Christoph Haller
I've seen statements like this if exists (select * from pg_tables where tablename = 'http://archives.postgresql.org