[SQL] Reading from file without superuser privilege

I need to read from a file in order to update a table. The manual says that it is necessary to have the superuser privilege to read from a file. Is it possible to read files without this privilege? Thanks. ___ José Antonio Quintana Romero Unitat de

[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

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

forms are slow Regards Pavel Stehule 2011/7/13 Jose Ig Mendez jmen...@andago.com Hi everybody, I'm trying to compare in a sentence like this (using PostGres 8.3) : select

[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

Re: [SQL] indexing longish string

Why don't you use some type of hash like md5 for indexing ? 2010/11/30 Rob Sargent robjsarg...@gmail.com: Were we to create a table which included a text field for a small block of xml (100-1000 chars worth), would an index on that field be useful against exact match queries? We're wondering

[SQL] Question about POSIX Regular Expressions performance on large dataset.

Hi! I'm analyzing the possibility of using PostgreSQL to store a huge amount of data (around 1000M records, or so), and these, even though are short (each record just have a timestamp, and a string that is less than 128 characters in length), the strings will be matched against POSIX Regular

Re: [SQL] Question about POSIX Regular Expressions performance on large dataset.

* search? (there are no joins, and will never be). I think it should, but: what do you think? Ildefonso. On Tue, Aug 17, 2010 at 9:51 PM, Jose Ildefonso Camargo Tolosa ildefonso.cama...@gmail.com wrote: Hi! I'm analyzing the possibility of using PostgreSQL to store a huge amount of data (around

Re: [SQL] Using count on a join, group by required?

On Wed, Aug 11, 2010 at 8:09 AM, Peter Eisentraut pete...@gmx.net wrote: On tis, 2010-08-10 at 22:21 -0430, Jose Ildefonso Camargo Tolosa wrote: And it works, it gives me something like:  product_id |         name         |     code      | manufacturer_id |     manufacturer_name

[SQL] Using count on a join, group by required?

Greetings! First: This is working, I just need a clarification on concept, so, it is not necessary for you to look deeply at the SQL statement. I have this: Table: products that references manufacturer via products.manufacturer_id to manufacturer.id (not important, just informative). Table:

Re: [SQL] SQL Developer accessing PostgreSQL

Squirrel been tested. It is opensource, and is done in Java using JDBC to support many databases. It is a universal SQL client, see http://www.squirrelsql.org/ El 29/03/10 18:22, Hiltibidal, Rob escribió: SQL Developer accessing PostgreSQL I recommend Aqua Data Studio  

[SQL] Composite Types

Hello I am using postgres r8.1 and i make 2 Composite Types as: CREATE TYPE regiao AS (pais_nome varchar(150), estado_nome varchar(150), estado_sigla varchar(4), cidade_nome varchar(150));ALTER TYPE regiao OWNER TO postgres;== and CREATE TYPE telcontato AS (telefone1

[SQL] MySQL DB to PostgresSQL DB

? - If is posible, How do I need to build the DB in MySQL?, in order to have success in the exportation. - Do someone did it before?, exporting MySQL DB to PostgreSQL DB? - What kind of risk do we can to have in this process? - How long can take this process? Thanks in advance. Jose

[SQL] Function in C++

in C++ if I reject the idea of use ODBC. Any help will be appreciated. Thans Jose Mendoza [EMAIL PROTECTED]

[SQL] prosgrees + java + trasnacciones

Hola a todos! Intento hacer una aplicacion en java que va contra pgsql y me gustaria bloquear registros. Un jps llama a un metodo de una clase para modificar un registro. Lo primero que hace es una consulta del registro (aquí quiero bloquear el registro) y despues se muestra en el navegador el

[SQL] problem with the Index

I have a problem with the index of 1 table. I hava a table created : CREATE TABLE acucliart ( cod_pto numeric(8,0) NOT NULL, cod_cli varchar(9) NOT NULL, mes numeric(2,0) NOT NULL, ano numeric(4,0) NOT NULL, int_art numeric(5,0) NOT NULL, cantidad numeric(12,2),

Re: [SQL] count( distinct x )

The problem I have is with this statement: select count( distinct area ) from areapostcode where postcode like 'BS1%' the above statement fails with ERROR: parser: parse error at or near "distinct" I am not the greatest when it comes to SQL, but the pgsql docs implied that the

[SQL] Function that returns a tuple.

How can I write a function in sql or pl- pgsql that returns a set of tuples ? Thanks. Claudio