Hello all, I am new to the list. I am trying to achieve a goal in PERL. That is: I have a table say students with fields (id int, name char(10) ) . I have data like:-
ID NAME == ========== 1 Kamran 2 Imran 3 Amir 4 Abid I have an array in perl as :- my @ids = (1,2,3) ; I want to select those records from the table students , which do not have ID in the array @ids. (This should give me 4 and 'Abid' ) . I am trying to do it as the follwoing code:- ########################## code snip start ######################### my @ids = (1,2,3) ; my $SQL = "select * from students where id in (@ids)"; # I am using the syntax of subquery in the above line . my $sth = $slavedbh->prepare($SQL) || die "Cannot prepare SQL statement\n"; my $howmany = $sth->execute || die "Cannot select from table\n"; ######################### code snip end ############################ I am using Postgresql 7.3 on Redhat Linux 9. I have perl 5. Rather everything is what comes bundled with Redhat 9. nothing extra. I don't know if this problem has been addressed in past. If so please point me in the right direction. Thanks in advance for your time and help. Kamran
