[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 "id", of course

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

) other 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

[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] indexing longish string

Why don't you use some type of hash like md5 for indexing ? 2010/11/30 Rob Sargent : > 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 if a criterion s

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

*one table* 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 wrote: > Hi! > > I'm analyzing the possibility of using PostgreSQL to store a huge > amount of data (

[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 E

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

On Wed, Aug 11, 2010 at 8:09 AM, Peter Eisentraut 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 | >>     manufactu

[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: prod

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   (te

[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 res

[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(1

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 >

[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