[SQL] Postgres 8.0.1 on Solaris 10 Sparc: library -lgcc_s: not found

I am installing Postgres 8.0.1 on Solaris 10 Sparc:   I am getting this error   gcc -shared -h libascii_and_mic.so.0  ascii_and_mic.o -L../../../../../../src/port   -o libascii_and_mic.so.0.0 ld: fatal: library -lgcc_s: not found ld: fatal: library -lgcc_s: not found ld: fatal: File

Re: [SQL] Postgres 8.0.1 on Solaris 10 Sparc: library -lgcc_s: not

Hello. You (Dinesh Pandey) wrote: > I am installing Postgres 8.0.1 on Solaris 10 Sparc: > [...] > I am getting this error > [...] > ld: fatal: library -lgcc_s: not found How did you configure? I built 8.0.2 using ./configure --prefix=/opt/local (i.e. nothing special) on a fresh Solaris 10 03/05

Re: [SQL] Help to drop table

DROP TABLE "Facility Info" Thank you, Igor "Michael Fuhr" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Fri, Apr 22, 2005 at 03:24:10PM +1000, Igor Kryltsov wrote: > > > > Please help to drop table with soace inside name. > > > > > > List of relations > >

[SQL] Division in Postgre

In sql server my division select cast(3 as float)/10 is 0.299. But in postgres select cast(3 as float8)/10 is 0.3. How to get result like sql server? Thank you. Sorry for my english ---(end of broadcast)--- TIP 5: Have you checked our extensi

[SQL] Build issues: "-static" builds resulting initdb problems

Version: 8.0.2   Platforms: Linux, Fedora Core 2, Suse 9.2, Mandrake 10.1   Build time parameter: CFLAGS="-static" ./configure           results in a staticly linked binaries. (you are supposed to have static lib versions of readline, ncurses, etc, etc. of course)   However, conversion share

[SQL] can someone jelp me on this?

hey guys I have a question that I couldnt maneged to solve for the last 4 days. Im kinda new to these stuff so dont have fun with me if it was so easy. Ok now heres the question. create table student (student_id int not null, student_name varchar(25), student_affiliation int, student_password va

Re: [SQL] Coming from Oracle SQL

Thank you Mike - and SO SORRY all!  I'm a newbie to this forum and the style is not customary to me! :-) Thanks again! Ronni Michael Fuhr <[EMAIL PROTECTED]> 04/25/2005 03:36 PM Please respond to pgsql-sql@postgresql.org To Veronica L Bounmixay <[EMAIL PROTECTED]> cc pgsql-sql@p

[SQL] Question about update syntaxt

I am trying to use an application (Through ODBC) that uses the following update syntax UPDATE MyTable SET MyTable.id=2 WHERE id=1 unfortunatly I get an error message ERROR: column "mytable" of relation "mytable" does not exist Question is, is ther something I can configure that will make Post

Re: [SQL] UPDATE WITH ORDER BY

Hi,       To my knowledge it is not possible to sort and update the code in a single update statement. I have done it through a simple function. I have given the function below.   CREATE OR REPLACE FUNCTION SortCode()RETURNS INT4 AS $$DECLARE  rRec RECORD;BEGIN  PERFORM SE

Re: [SQL] Looking for a way to sum integer arrays....

Thank you for the responses! To recap: pl/r array support works very well. In my case, I am looking for pl/pgsql solution. I also got this nice function from dennisb on the #postgresql irc channel, which seems extremely "clean" and works with 7.4/8.0. My original function didn't handle a blank i

[SQL] Postgres 8.0.0 - unknown log string

Hi, I found in my postges 8.0 logs (/var/lib/pgsql/data/pg_log/postgresql-Thu.log) LOG: incomplete startup packet LOG: incomplete startup packet very very times. What's it? I did't found answers in the postgres documentation. Can someone explain me about it? Thanks, Mauro B. _

[SQL] multi-column unique constraints with nullable columns

I have many tables who's natural key includes a nullable column. In this cases it's a soft-delete or 'deprecated' date time. I'd like to add a table constraint enforcing this constraint without writing a custom procedure, but I've found that postgres treats NULLs very consistently with respect

Re: [SQL] Looking for a way to sum integer arrays....

Hi, CREATE OR REPLACE FUNCTION SUM_ARR( aArr1 Integer[] , aArr2 Integer[] ) RETURNS Integer[] AS $$ DECLARE aRetu Integer[]; BEGIN -- Initialize the Return array with first array value. FOR i IN array_lower( aArr1 )..array_upper( aArr1 ) LOOP array_append( aRetu , aArr1[i] ); END L

[SQL] PHP postgres connections

Hi, I need to connect to 2 differents Postgres 8.0.0 databases located in the same machine using the same PHP script with an "db wrapper object" instance (pg_Connect)... simply a PHP page with contemporarily 2 database connections... What's the best practice ? Can I use however persistent connec

Re: [SQL] people who buy A, also buy C, D, E

Hi I am bit confused.. If you want to display first 5 the following query will fetch top 5 book id's. I am not able to understand, why there is a sub-query. SELECT ELEMENT_ID , COUNT( * ) FROM WATCH_LIST_ELEMENT GROUP BY ELEMENT_ID ORDER BY COUNT(*) DESC LIMIT 5 Regards, R.Muralidhar

Re: [SQL] trigger/rule question

Hi, Going through you mail, I assume that you are updating the mtime only after inserting the record. It is always possible to check the mtime filed value of the inserted record and take action based on it in the trigger. Is it possible to send me detail about the trigger? Regards, R.

Re: [SQL] Question about update syntaxt

On Fri, 29 Apr 2005, Michael M Friedel wrote: > I am trying to use an application (Through ODBC) that uses the > following update syntax > > UPDATE MyTable SET MyTable.id=2 WHERE id=1 > > unfortunatly I get an error message > > ERROR: column "mytable" of relation "mytable" does not exist > > Ques

Re: [SQL] Division in Postgre

On Sun, 24 Apr 2005, tuan wrote: > In sql server my division select cast(3 as float)/10 is 0.299. > But in postgres select cast(3 as float8)/10 is 0.3. How to get result like > sql server? I believe you can control what precision is used in printing the float results with extra_float_digi

Re: [SQL] multi-column unique constraints with nullable columns

On Fri, 29 Apr 2005, Tornroth, Phill wrote: > I have many tables who's natural key includes a nullable column. In this > cases it's a soft-delete or 'deprecated' date time. I'd like to add a > table constraint enforcing this constraint without writing a custom > procedure, but I've found that post

Re: [SQL] PHP postgres connections

Hi, I need to connect to 2 differents Postgres 8.0.0 databases located in the same machine using the same PHP script with an "db wrapper object" instance (pg_Connect)... simply a PHP page with contemporarily 2 database connections... I don't think this is the right place to ask this, but there's an

Re: [SQL] Build issues: "-static" builds resulting initdb problems

"Metin Ozisik" <[EMAIL PROTECTED]> writes: > Build time parameter: CFLAGS="-static" ./configure Is there a particular reason for you to be doing that? > creating conversions ... FATAL: could not load library = > "../ascii_and_misc.so": ../../ascii_and_misc.so: undefined symbol: = > pg_mic2asc