[SQL] newbie question * compare integer in a "where IN" statement

Title: Firma Correo Hi everybody, I'm trying to compare in a sentence like this (using PostGres 8.3) : select * from myTable where id_integer IN ('1,2,3,4') I want to get the records which key "id_integer" is 1 or 2 or 3 or 4. the type od my "id", of course

Re: [SQL] newbie question * compare integer in a "where IN" statement

Title: Firma Correo Hi, Thank you very much Pavel, that solves my problem Regards On 13/07/11 09:50, Pavel Stehule wrote: Hello you can try SELECT .. FROM .. WHERE id = ANY(string_to_array('1,2,3,4,5',',')) other forms

Re: [SQL] newbie question * compare integer in a "where IN" statement

Hello you can try SELECT .. FROM .. WHERE id = ANY(string_to_array('1,2,3,4,5',',')) other forms are slow Regards Pavel Stehule 2011/7/13 Jose Ig Mendez > > Hi everybody, > > I'm trying to compare in a sentence like this (using PostGres 8.3) : > > select * from myTable where id_integer IN (

Re: [SQL] newbie question * compare integer in a "where IN" statement

Jose Ig Mendez, 13.07.2011 09:36: Hi everybody, I'm trying to compare in a sentence like this (using PostGres 8.3) : select * from myTable where id_integer IN ('1,2,3,4') I want to get the records which key "id_integer" is 1 or 2 or 3 or 4. the type od my "id", of course, is integer. I've t

[SQL] newbie question * compare integer in a "where IN" statement

Title: Firma Correo Hi everybody, I'm trying to compare in a sentence like this (using PostGres 8.3) : select * from myTable where id_integer IN ('1,2,3,4') I want to get the records which key "id_integer" is 1 or 2 or 3 or 4. the type od my "id",

Re: [SQL] newbie question

On Fri, Mar 03, 2006 at 12:30:20PM +0100, ivan marchesini wrote: > another question... > is it possible to copy a table to a view and then back the view to a > table??? You need to read a basic textbook about what a view is. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 7

Re: [SQL] newbie question

am 03.03.2006, um 12:30:20 +0100 mailte ivan marchesini folgendes: > Thanks to all... > another question... > is it possible to copy a table to a view and then back the view to a > table??? Yes this is possible. > > Il giorno ven, 03/03/2006 alle 11.51 +0100, Andreas Kretschmer ha please, no s

Re: [SQL] newbie question

Thanks to all... another question... is it possible to copy a table to a view and then back the view to a table??? thank you very much... ivan Il giorno ven, 03/03/2006 alle 11.51 +0100, Andreas Kretschmer ha scritto: > ivan marchesini <[EMAIL PROTECTED]> schrieb: > > > Dear users.. > > I have

Re: [SQL] newbie question

On Fri, Mar 03, 2006 at 10:43:09AM +0100, ivan marchesini wrote: > I have fastly created a table in a postgresql database.. > some columns where edited by hand (columns A, B, C), and some others > (columns D, E, F) have been calculated as a result of mathematical > equation (where the factors are

Re: [SQL] newbie question

ivan marchesini <[EMAIL PROTECTED]> schrieb: > Dear users.. > I have fastly created a table in a postgresql database.. > some columns where edited by hand (columns A, B, C), and some others > (columns D, E, F) have been calculated as a result of mathematical > equation (where the factors are the A

[SQL] newbie question

Dear users.. I have fastly created a table in a postgresql database.. some columns where edited by hand (columns A, B, C), and some others (columns D, E, F) have been calculated as a result of mathematical equation (where the factors are the A, B, C columns) now I simply need to change some val

Re: [SQL] newbie question

> Transactions (well, recently mysql allows them but using propietary > extensions), foreign key relationships, subqueries, stored > procedures/triggers. MySQL lacks all of these. MySQL's InnoDB tables have foreign keys, but they are RESTRICT only - ie. they're kinda useless. > On the other side

Re: [SQL] newbie question

On Sun, 7 Jul 2002, Mirco D'Angelo wrote: > Hi > > I am going to learn MySql 'cause I have to, but would it be better, or let's > say, more interesting, to learn postgressql? Is it newer, more common, etc.? > Well IMO you just cant compare them. Think of a porche that does 100km/h better than

Re: [SQL] newbie question

Transactions (well, recently mysql allows them but using propietary extensions), foreign key relationships, subqueries, stored procedures/triggers. MySQL lacks all of these. On the other side, postgres is only ported on *nix platforms, but you can put cygwin/cygipc on Windows, if that is the c

Re: [SQL] newbie question

On Sunday 07 Jul 2002 10:59 pm, Mirco D'Angelo wrote: > Hi > > I am going to learn MySql 'cause I have to, but would it be better, or > let's say, more interesting, to learn postgressql? Is it newer, more > common, etc.? Mysql is more common on web-hosting platforms, but you can find PostgreSQL i

Re: [SQL] newbie question

On Sun, Jul 07, 2002 at 11:59:51PM +0200, Mirco D'Angelo wrote: > Hi > > I am going to learn MySql 'cause I have to, but would it be better, or let's > say, more interesting, to learn postgressql? Is it newer, more common, etc.? PostgreSQL is certainly more interesting, more useful, more feature

[SQL] newbie question

Hi I am going to learn MySql 'cause I have to, but would it be better, or let's say, more interesting, to learn postgressql? Is it newer, more common, etc.? greets mirco ---(end of broadcast)--- TIP 6: Have you searched our list archives? htt

Re: [SQL] Newbie question on how to check triggers created

Chunky wrote: > > Could someone please enlightenment me what command in psql i should use > to show the various triggers and rules that i have created? These might work... select tgname from pg_trigger select rulename from pg_rewrite Regards, Ed Loehr

[SQL] Newbie question on how to check triggers created

Hi folks, Could someone please enlightenment me what command in psql i should use to show the various triggers and rules that i have created? Thanks alot in advance. Regards Damon /* Please be gentle with me, i'm a newbie. */