[SQL] Requirement for PostgreSQL Database Developer
Hi , Location: San Diego, CA [You can also TeleCommute but you have to be on the client side for 2 Weeks in a month] Duration: 6+ months. This is Mark with ProV International, This email is in regards to the requirement we have with one of our direct client in San Diego, CA. PostgreSQL Database Developer This position involves creating tables, views, functions and stored procedures to support front end OLTP and reporting applications. The ideal developer will have thorough knowledge of SQL (PL/pgSQL), experience with at least one other PostgreSQL language (e.g. PL/Perl), and extensive experience with complex stored procedures, code optimization, and index tuning in PostgreSQL. Ideal candidate will have the following qualifications: 5+ years database development with PostgreSQL Knowledge of at least one other language in addition to PL/pgSQL, such as PL/Perl or PL/Java. Experience implementing PostgreSQL replication . Some experience with either SQL Server 2000 or Oracle 9i/10g. Significant background in creating complex stored procedures and SQL scripts Understanding of database normalization concepts Some experience in logical and physical database design and implementation Prior experience working in a project oriented environment and meeting deadlines under tight time constraints Strong analytical skills Capable of working independently with minimal supervision. If you find yourself comfortable with this job profile & find it interesting please send me your resume in MS Word Format. thanks , Mark, ProV International Tampa, FL 33607 Tel 408 - 241 - 7795 Xtn - 27 [EMAIL PROTECTED] www.provintl.com
[SQL] SELECT with WHERE clause by column number
Hi! I need to make a query like this: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this because there's a situation in my program where I don't have the column name. I've solved that querying Postgresql the name of the column with that number, and then creating the SELECT query. But this solution is slow... two database calls... Can I do this with a single query or in a faster way through SQL, an internal function or through a Procedural Language? Thanks Carlos Henrique Iazzetti Santos Compels Informática Santa Rita do Sapucaí - MG BRAZIL www.compels.net ___ Você quer respostas para suas perguntas? Ou você sabe muito e quer compartilhar seu conhecimento? Experimente o Yahoo! Respostas ! http://br.answers.yahoo.com/
Re: [SQL] SELECT with WHERE clause by column number
Carlos Santos wrote: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this because there's a situation in my program where I don't have the column name. I've solved that querying Postgresql the name of the column with that number, and then creating the SELECT query. But this solution is slow... two database calls... If you don't know what the column is, how do you know what you are testing against? Or what type it is, for that matter? Anyway, just have build a list of column-name,column-type pairs for relevant tables at application start-up, or store it in a configuration file. Unless you're building/changing tables all the time, that should work. I'm curious as to what type of application can usefuly query a database without knowing what structure it has. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [SQL] SELECT with WHERE clause by column number
On 12/18/06, Carlos Santos <[EMAIL PROTECTED]> wrote: Hi! I need to make a query like this: SELECT id FROM myTable WHERE column-number = 'value'; (PS: The id column is the primary key of myTable). That is a select using column number in the WHERE clause what don't exists in SQL. I need this because there's a situation in my program where I don't have the column name. I've solved that querying Postgresql the name of the column with that number, and then creating the SELECT query. But this solution is slow... two database calls... Can I do this with a single query or in a faster way through SQL, an internal function or through a Procedural Language? Can you provide the 2 queries you used to successfully do this in two database calls? I am not sure that select makes sense. Where clauses work on rows, not columns. Having your two working queries will help us see what you are really trying to do. -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==
Res: [SQL] SELECT with WHERE clause by column number
All my columns have the same data type: text. So it's much easier. Carlos Henrique Iazzetti Santos Compels Informática Santa Rita do Sapucaí - MG www.compels.net - Mensagem original De: Richard Huxton Para: Carlos Santos <[EMAIL PROTECTED]> Cc: Lista PostgreSQL SQL Enviadas: Segunda-feira, 18 de Dezembro de 2006 15:25:27 Assunto: Re: [SQL] SELECT with WHERE clause by column number Carlos Santos wrote: > SELECT id FROM myTable WHERE column-number = 'value'; > (PS: The id column is the primary key of myTable). > > That is a select using column number in the WHERE clause what don't exists in > SQL. > > I need this because there's a situation in my program where I don't have the > column name. > I've solved that querying Postgresql the name of the column with that number, > and then creating the SELECT query. > But this solution is slow... two database calls... If you don't know what the column is, how do you know what you are testing against? Or what type it is, for that matter? Anyway, just have build a list of column-name,column-type pairs for relevant tables at application start-up, or store it in a configuration file. Unless you're building/changing tables all the time, that should work. I'm curious as to what type of application can usefuly query a database without knowing what structure it has. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com
Re: [SQL] SELECT with WHERE clause by column number
On mán, 2006-12-18 at 09:17 -0800, Carlos Santos wrote: > > SELECT id FROM myTable WHERE column-number = 'value'; > (PS: The id column is the primary key of myTable). > > That is a select using column number in the WHERE clause what don't > exists in SQL. > > I need this because there's a situation in my program where I don't > have the column name. > I've solved that querying Postgresql the name of the column with that > number, and then creating the SELECT query. > But this solution is slow... two database calls... > > Can I do this with a single query or in a faster way through SQL, an > internal function or through a Procedural Language? this can be done with the more dynamic prodedural languages. this should be possible too with pl/pgsql using your first query + EXECUTE this is still 2 queries, but only one client round-trip. this can also be done in one SQL query with some creative misuse of an UNION ALL within a subquery, if you know the number of columns in your table. gnari ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
