[GENERAL] Character encoding problem using Tcl

I use PostgreSQL 7.0.3 on Linux (i386) platform, Tcl 8.3 is installed. When entering National special characters (e.g. accented german characters) by use of psql into a database, all seems to be ok., the special characters appear correct on queries (locale seems to work well in this case).

[GENERAL] More on character encoding in SELECTs

I'm running PostgreSQL 7.0.3 on RedHat 7.0 eng. In the database I have several lines of data beginning with "Å", "Ä" or "Ö" (swedish special characters). When I do a SELECT xx FROM xx WHERE xx = 'Å' in psql, it returns lines where xx is starting with "A". With "Ö", it returns lines where xx

[GENERAL] Sequence

Where can i get help, or some tutoral that talks about the "sequence" (create sequence) statment. thanks! Gerardo Gerardo Tagliani Linux Registred User #139437 --- FREE! The World's Best Email Address @email.com Reserve your name now at

Re: [GENERAL] Sequence

The User's Guide covers the "CREATE SEQUENCE" statement quite well. gerardo tagliani wrote: Where can i get help, or some tutoral that talks about the "sequence" (create sequence) statment. thanks! Gerardo Gerardo Tagliani Linux Registred User #139437

[GENERAL] check constraint

Hi, how should I write a constraint that can keep an INT field with values between 0 and 10? Do I have to use two checks on the same field? TIA -- System Administration: It's a dirty job, but someone told I had to do it.

Re: [GENERAL] check constraint

You should be able to do the following: CREATE TABLE table1 ( field1 INTEGER CHECK ((field1 = 0) AND (field1 = 10)) ); Wade Oberpriller Hi, how should I write a constraint that can keep an INT field with values between 0 and 10? Do I have to use two checks on the same field? TIA

Re: [GENERAL] check constraint

El Lun 18 Dic 2000 12:43, Wade D. Oberpriller escribió: You should be able to do the following: CREATE TABLE table1 ( field1 INTEGER CHECK ((field1 = 0) AND (field1 = 10)) ); Thanks!!! Didn't know that! -- System Administration: It's a dirty job, but someone told I had to do it.

[GENERAL] Carrage Returns \ Line Breaks!

Hello all, I have a file that I am trying to import/copy into a table. The problem that I am having is that there are carriage returns through out the document. These carriage returns should be copied into the column it belongs to yet during the copy table from '/home/location/file.ext'

[GENERAL] functions / store procedures

Can JDBC ResultSets be returned from user defined functions with postgreSQL? Is there more documentation for functions then is available on www.postgresql.org? Thanks, Joel

Re: [GENERAL] Carrage Returns \ Line Breaks!

On Mon, 18 Dec 2000, Brian C. Doyle wrote: I have a file that I am trying to import/copy into a table. The problem that I am having is that there are carriage returns through out the document. These carriage returns should be copied into the column it belongs to yet during the copy table

Re: [GENERAL] Carrage Returns \ Line Breaks!

Okay now I am an Idoit. How do I tell what is used for the carriage return? I know how to make the replacement I just can not tell they characters used. At 11:52 AM 12/18/00 -0500, Brett W. McCoy wrote: On Mon, 18 Dec 2000, Brian C. Doyle wrote: I have a file that I am trying to

Re: [GENERAL] Carrage Returns \ Line Breaks!

On Mon, 18 Dec 2000, Brian C. Doyle wrote: Okay now I am an Idoit. How do I tell what is used for the carriage return? I know how to make the replacement I just can not tell they characters used. Are you on Windows, Unix or Mac? -- Brett

Re: [GENERAL] Whoohoo!

Mine _arrived_ last Thurday from Barnes and Noble. No notice about shipping though! Rod -- On Sun, 17 Dec 2000, Brett W. McCoy wrote: [snip] Greetings from Amazon.com. We thought you'd like to know that we shipped your items today, and that this completes your order. ... The

[GENERAL] Schema

How can i get a schema of my database??? (structures of tables, indexes, triggers, rules, etc, etc ..) Thanks! Gerardo Tagliani Linux Registred User #139437 --- FREE! The World's Best Email Address @email.com Reserve your name now at

[GENERAL] PL/pgSQL Trigger Problems

I'm having problems getting a simple PL/pgSQL trigger to work. I suspect that something may not be set up correctly, but I have no idea what. Specifically, I'm trying to get the example working in the 'PL/pgSQL Trigger Procedure' section of the documentation (located at:

Re: [GENERAL] question

Hi, I reduced my trigger to do following : (Trigger gets invoked for Table1 in Db1) 1. conn=PQconnectdb ( db2 ) 2. PQexec(conn,"begin") --- FAILS 3. PQfinish(conn) I get failure in step (2) with following message in 'postmaster.log' ERROR: begin pq_recvbuf:

[GENERAL] Are arrays broken in 7.0.3?

Can someone help me understay array usage in postgresql? After reading the user manual (ch8), I tried to create a 2-d array of float8s... and yet the database seems broken: when I ask for a row back I get nothing! Or, if I ask for a row another way, I get two rows! Please help! Jason p.s. how

[GENERAL] a huge table with small rows and culumns

hi, I have been a postgres user for serveral months. But recently I find a "mysterious" things in my /usr/local/pgsql/data/base/The_Database_Name/The_table_name. In a particular table name "fred" there are only 50 rows and 13 columns. The column types are int, float, varchar, where varchar's

Re: [GENERAL] a huge table with small rows and culumns

Do you do a lot of updates and/or deletes? If so, you need to VACUUM your database. When rows are modified, they are not actually deleted. They are just flagged to be ignored. Vacuum cleans up the rows. Adam Lang Systems Engineer Rutgers Casualty Insurance Company