[SQL] Problem in SQL Trigger

Hii have one problem in Trigger.this trigger alread workon Red Hat Linux 7.3 but now i shift to RHL9.0in RHL 9.0  notworking . in this problem in ROUND function.but how to i slove thisi dont know. so please help me.This is  Function andTrigger./// Function Start/

Re: [SQL] Multi ordered select and indexing

Have you thought of using a functional index on both columns? Regards, Christoph > > Hi! > What is the simplest solution for this query type: > > SELECT * FROM tablename ORDER BY col1 ASC, col2 DESC; > > In our experience, postgres cannot use a multi-colum index on (col1, > col2) in t

[SQL] Equivalant of SQL Server's Nchar and NVARCHAR

Dear friends, Is there any equivalent datatype of SQL Server's NCHAR and NVARCHAR, available with Postgres 7.3.4. I want to store characters, special characters and Numbers. Please shed some light.   Thanks Kumar

Re: [SQL] Equivalant of SQL Server's Nchar and NVARCHAR

> Dear friends, > Is there [...] > Please shed some light. http://www.postgresql.org/docs/7.4/static/index.html > Thanks You are welcome. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---(end of broadcast)---

Re: [SQL] Equivalant of SQL Server's Nchar and NVARCHAR

kumar wrote: Dear friends, Is there any equivalent datatype of SQL Server's NCHAR and NVARCHAR, available with Postgres 7.3.4. I want to store characters, special characters and Numbers. Please shed some light. Thanks Kumar I only only use ascii but... I believe postgresql varchar is the same a

Re: [SQL] Use arrays or not?

Roelant, Yours is not a performance question, so I'm crossing it over to SQL for advice on database design. > I am building an application using postgresql to store XML-records. There > is a debate within the group of developers about the best way to store our > data. I hope you can help us make

[SQL] Check a value in array

Hi all. I have to check if a value is in an array. I've got a date array in a table and I would like to perform queries like: SELECT * FROM table WHERE date IN dates_array; I've tried using array_contains_date (contrib/array_iterator.sql) function unsuccessfully: SELECT array_contains_date(dat

Re: [SQL] Check a value in array

On Thu, 2004-04-29 at 13:37, Marco Lazzeri wrote: > Hi all. > > I have to check if a value is in an array. > > I've got a date array in a table and I would like to perform queries > like: > > SELECT * FROM table WHERE date IN dates_array; If you're using 7.4 or later, try: SELECT * FRO

Re: [SQL] Equivalant of SQL Server's Nchar and NVARCHAR

Kumar, > I only only use ascii but... > I believe postgresql varchar is the same as Oracle/Sybase/MS SQL > nvarchar even though it doesn't explicitly say so here: All of our TEXT datatypes are multibyte-capable, provided you've installed PostgreSQL correctly.This includes: TEXT (recommended

Re: [SQL] Multi ordered select and indexing

"Antal Attila" <[EMAIL PROTECTED]> writes: > CREATE OPERATOR CLASS int4_reverse_order_ops > FOR TYPE int4 USING btree AS > OPERATOR1 /< , > OPERATOR2 /<= , > OPERATOR3 /= , > OPERATOR4 />= , >

[SQL] Permissions not working

Hi , I am having some problems with setting up permissions in Postgres. I have a database for ex: 'ups' and it was owned previously by 'postgres(superuser)' but now i have changed the ownership to new user 'ups' all the tables are owned by these user 'ups'. This database doesnt have any sche

Re: [SQL] Use arrays or not?

Roelant, > So, let me rephrase my questions: > 1. When and why would anyone use arrays? When the data itself is an ordered set of items which is indivisible and lacks meaning outside the ordered set. For example, a set of ordered pairs of molecules in a gene snippet. Or a mathematical matrix

Re: [SQL] Permissions not working

On Thu, 29 Apr 2004, Pallav Kalva wrote: > Hi , > > I am having some problems with setting up permissions in Postgres. I > have a database for ex: 'ups' and it was owned previously by > 'postgres(superuser)' but now i have changed the ownership to new user > 'ups' all the tables are owned

Re: [SQL] Permissions not working

scott.marlowe wrote: On Thu, 29 Apr 2004, Pallav Kalva wrote: Hi , I am having some problems with setting up permissions in Postgres. I have a database for ex: 'ups' and it was owned previously by 'postgres(superuser)' but now i have changed the ownership to new user 'ups' all the tables a

Re: [SQL] Permissions not working

On Thu, 29 Apr 2004, Pallav Kalva wrote: > scott.marlowe wrote: > > >On Thu, 29 Apr 2004, Pallav Kalva wrote: > > > > > > > >>Hi , > >> > >>I am having some problems with setting up permissions in Postgres. I > >>have a database for ex: 'ups' and it was owned previously by > >>'postgres(s

[SQL] isnumeric() function?

What is isnumeric function in postgresql? I'm using psql version 7.2.2 thanks Yudie ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] Permissions not working

Pallav Kalva <[EMAIL PROTECTED]> writes: > I have a database for ex: 'ups' and it was owned previously by > 'postgres(superuser)' but now i have changed the ownership to new user > 'ups' all the tables are owned by these user 'ups'. That isn't a supported operation. How did you do it exactly?