On Sat, 2013-05-25 at 14:49 +0200, Brice André wrote:
Hi Wolfe,
First, thanks for your help.
I tried your code, but it does not work... the function returns a string :
0. When I check, this command properly modifies one row, as expected.
It works for me with PQntuples.
I don't know if
On Thu, 2013-04-18 at 13:21 +0200, Marcin Krawczyk wrote:
I figured it out... when changing role from pgAdmin, it has a default VALID
UNTIL 1970 set and after confirming changes it just made my abc user
account invalid...
FYI, this pgAdmin bug has been fixed. The fix will be available in the
On Wed, 2012-11-28 at 21:21 -0600, Seb wrote:
Hi,
I use \copy to output tables into CSV files:
\copy (SELECT ...) TO 'a.csv' CSV
but for long and complex SELECT statements, it is cumbersome and
confusing to write everything in a single line, and multiline statements
don't seem to be
On Thu, 2012-03-22 at 16:26 -0400, Edward W. Rouse wrote:
I am currently using lower(column) = '' for matching case insensitive. I
know that there are ways to do this with regular expressions too. I recently
noticed that including even one lower causes severe performance issues (from
290ms to
On Thu, 2011-10-20 at 04:15 -0700, Scott Swank wrote:
Here is a seeming quirk in pgadmin3. I say seeming, because I may
simply not be sufficiently familiar with this tool.
[A quick note for non-mac users, the Finder is the gui file browser,
equivalent to Nautilus/Dolphin in linux or the
On Thu, 2011-10-20 at 12:22 +0200, Guillaume Lelarge wrote:
On Wed, 2011-10-19 at 01:13 -0700, Basil Bourque wrote:
[...]
I may have once had an inexplicable glitch, but after restart all was well.
I've only been bitten by 2 recurring bugs:
• (Cosmetic) Changing font size for use
On Wed, 2011-10-19 at 01:13 -0700, Basil Bourque wrote:
I have a postgres 9.1 database up running, no problem. Purely in
terms of writing sql (ddl, dml pg/plsql), what tools are
recommended?
Coming from an Oracle world, I'm thinking of toad, sql developer, etc.
1. psql text
On Wed, 2011-10-19 at 12:11 +0200, Brice André wrote:
Hello everyone,
I would want to implement an SQL query where I would be able to suppress all
information from a registered user. I am currenlty able to suppress
everything except the user role. The name of the role is present in a table
Hi,
On Sun, 2011-10-09 at 18:50 +0200, F. BROUARD / SQLpro wrote:
I am answering to myseilf...
the good syntax is something like :
CREATE RULE R_U_MSR_BEFORE2000x
AS
ON UPDATE TO T_MESURE_MSR
WHERE ( NEW.MSR_DATE DATE '2000-01-01' )
DO INSTEAD
(
-- rows does not change
On Sun, 2011-10-09 at 21:17 +0200, F. BROUARD / SQLpro wrote:
Hi,
Le 09/10/2011 19:07, Guillaume Lelarge a écrit :
Hi,
On Sun, 2011-10-09 at 18:50 +0200, F. BROUARD / SQLpro wrote:
I am answering to myseilf...
the good syntax is something like :
CREATE RULE
On Sat, 2011-09-17 at 16:56 +0200, Andreas wrote:
Am 13.09.2011 07:50, schrieb pasman pasmański:
In 8.4 this syntax is not implemented.
select * from (
update tbl set val = 1 where key in ( 1, 2, 3, 4, 5 ) returning *
) as x
wouldn't work even in PG 9.1.
So what data structure is
On Tue, 2011-07-12 at 10:33 +0200, B.Rathmann wrote:
[...]
I've been trying to find out how to find out which sql was run to create
a certain table. As I need this in a program which may access the
database remotely, using pg_dump --schema-only or psql is not an option
(the system my program
On Sat, 2011-06-11 at 17:01 +0200, Leif Biberg Kristensen wrote:
Can anybody tell me why this doesn't work?
Because it's not supported. The START clause expects a value, not a
subquery.
pgslekt= CREATE SEQUENCE sources_source_id_seq START WITH (SELECT
MAX(source_id) FROM sources);
ERROR:
On 05/07/2011 01:19 PM, Thomas Kellerer wrote:
Hi,
I'm playing around with 9.1beta1 and would like to create a table where
one column has a non-default collation.
But whatever I try, I can't find the correct name that I have to use.
My database is initialized as follows:
postgres=#
Le 26/11/2010 18:14, Thomas Kellerer a écrit :
ndias, 26.11.2010 17:22:
When doing a insert row with less columns mentioned in into table(col1,
col2, col3,... than the columns that exist on the table, on 1.10.1 it
returns an error saying INSERT has more expressions than target columns
(the
Le 24/09/2010 14:32, Nicholas I a écrit :
hi,
i am trying to dump a table with insert command rather tahn copy.
pg_dump -Dt --insert table dbname table.sql;
i am not able to get the output. is this correct ?
-Nicholas I
You should put the table name right after the -t
Le 22/09/2010 09:32, Nicholas I a écrit :
Hi,
i have two tables,
---
*table1
id type serial, name varchar;*
*--
table 2
name varchar;*
Hi,
Le 16/03/2010 08:40, Marcin Krawczyk a écrit :
Hi list, does anyone know the reason for pgAdmin not showing the stats
neither for selected pgAgent step nor whole job ? The pga_joblog and
pga_jobsteplog both get populated with data on run so I was thinking that
maybe I'm missing some view
Le 15/01/2010 17:13, Seb a écrit :
On Fri, 15 Jan 2010 07:35:17 +0100,
Guillaume Lelarge guilla...@lelarge.info wrote:
[...]
Primary keys are constraints. They are enforced with an index, but
actually they are constraints. So we put them on the constraints
nodes.
There is the same
Le mardi 24 novembre 2009 à 16:45:27, Richard Broersma a écrit :
I noticed a few new SQL references in the manual:
CREATE SERVER
CREATE FOREIGN DATA WRAPPER,
CREATE USER MAPPING
Is this similar to DBI-Link?
They appear on the 8.4 release. They were added to support the use of SQL/MED
Le jeudi 19 novembre 2009 à 01:20:24, Kris Kewley a écrit :
Could you not create a function to do this instead?
Set var_limit = 20% of row count
Replace subquery with var_limit
Sure, see the previous mails from Pavel. You can also put the percent as a
parameter of the function.
--
Hi Ivan,
Le vendredi 26 juin 2009 à 17:53:15, ivan marchesini a écrit :
[...]
I have installed a postgres db using a datadir different
from /var/lib/pgsql/.psql_history.
then:
su postgres
psql postgres
All went fine but when I exit from psql from a db I obtain:
___
could not
Judith Altamirano a écrit :
Hello every body I'm trying to extract a query as follows:
copy (select * from clientes where id_cliente = 7895) to
'/home/paso/sel.copy';
But it returns the next error:
ERROR: error de sintaxis en o cerca de «(» at character 6
LINE 1: copy (select * from
Hengky Lie a écrit :
[...]
I really amazed with this problem and need your help.
I run simple query from Query window of PgAdmin3: SELECT * FROM mytable
limit 10;
and the result are NON UPDATABLE QUERY, while i need the result are
updatable.
I run the same query from Passthrough SQL
Hengky Lie a écrit :
This is the same as what i think but the table has primary key and has
no relation to other table. This is the table definition :
[...]
These query result non updateable records :
SELECT kode, namabarang from tblproduk;
SELECT * from tblproduk;
What is the
Hengky Lie a écrit :
I have to use sql command because i want to retrieve data according to
several criteria.
The SQL command just a sample to show that the data i retrieve not
updateable. The real query like :
SELECT * FROM TBLPRODUK WHERE SUBKAT='abc';
So i do not need to view data
Nacef LABIDI a écrit :
Hi all,
I was wondering if there is a way to concatenate the results of a field
in a select to return it as a single string.
Example :
my_field
--
1
2
3
select concat_something(my_field) from my_table group by something;
the result expected
Sabin Coanda wrote:
Hi there,
I have a procedure where a dead-lock occurs, and I'm trying to find the
tables involved in the lock.
Unfortunatelly, I don't find the related objects of the oids of relation
field. Also all the fields classid and objid are null.
May I suppose there were
sad wrote:
A. Kretschmer wrote:
is it expected that the currval() changes its value between calls
within one statement ?
Conclusion, don't call nextval() within a TRIGGER, and insert either
nextval() for the column or omit this column.
I only note that i still want to discuss the titled
sad wrote:
Guillaume Lelarge wrote:
sad wrote:
A. Kretschmer wrote:
is it expected that the currval() changes its value between calls
within one statement ?
Conclusion, don't call nextval() within a TRIGGER, and insert either
nextval() for the column or omit this column.
I only note
Yohanes Purnomo a écrit :
[...]
I create a function:
CREATE OR REPLACE FUNCTION ReProses()
RETURNS BOOLEAN
AS $$
DECLARE
nHasil Numeric;
BEGIN
CREATE TEMP TABLE tmpTtlRekening WITHOUT OIDS ON COMMIT DROP
AS
SELECT Rekening, SUM(Debet) AS Debet,
A. R. Van Hook a écrit :
I have join problem:
select i.ivid, v.eventdate, v.deposit, v.invdate, cai.db,
sum(i.tax) as tax,
sum(i.tax + i.rowtot) as totalP,
(sum(i.tax + i.rowtot) - v.deposit) as balance
from invoice v
Bart Degryse a ecrit le 16/03/2007 10:03:
I don't use ASP but in PHP I would do something in the line of
$valuetoinsert = SANT'ANGELO LODIGIANO;
$query = INSERT INTO TABLE2 (TE_INDI) VALUES (' . str_replace(',
'', $valuetoinsert) . ');
I'm sure ASP has also a string replacement function
Shavonne Marietta Wijesinghe a ecrit le 16/03/2007 11:31:
i took a look at the link Guillaume gave me. But it also explains on PHP
i'm using ASP :(
Yes, that's why I said that it didn't answer your question. Sorry if
this wasn't clear.
After a bit of googling, I found the replace function.
Andreas Joseph Krogh a ecrit le 15/09/2006 10:06:
I have the following query:
select lower(firstname) || ' ' || lower(lastname) from person
firstname and lastname are VARCHAR
lower() returns NULL when firstname OR lastname is NULL, is this correct?
This is 8.2devel from 24.08.2006.
NULL
2006/5/18, Alvaro Herrera [EMAIL PROTECTED]:
Guillaume LELARGE wrote:
Emi Lu a écrit :
I am trying to insert one column to a specific position in a table.
In mysql, I can do:
. create table test(id varchar(3), name varchar(12));
. alter table test add column givename varchar(12) after
2006/5/18, Andrew Sullivan [EMAIL PROTECTED]:
On Thu, May 18, 2006 at 05:43:19PM +0200, Guillaume Lelarge wrote:
Do you mean that, using alter table test add column with the after
option, MySQL creates a new table, populates it with the old table
data and finally drops the old table ? I mean
Hi,
tnodev a écrit :
I'm using postGre with tables which contain French character (éèçàù...).
Is there a fonction which performs a like in replacing é (e cute) by e ?
select translate('forêt', 'àâäéèêëîïôöùûü', 'aaaiioouuu');
Change the first word (forêt) by the string you want
Johnny C wrote:
I have the following tables:
TABLE A
month | year | item | num
1 2005 myitem 003
TABLE B
num| date | descr
003 02-01-2005 blahblah
003 01-01-2005 toratora
I am trying to come up
Le Samedi 15 Novembre 2003 15:18, vous avez écrit :
Hello,
I have a table with many fields, and one of the fields is of type serial.
I will do many inserts, and there will be many repeats of the other fields
in the table, but, obviously, the serial field will be unique for all the
rows. How
Le Samedi 15 Novembre 2003 16:40, vous avez écrit :
Doing a select currval() from my_table after your insert should work.
Actually, this is
select currval('my_sequence')
Sorry about this.
For more details, see
http://www.postgresql.org/docs/7.3/interactive/functions-sequence.html
--
Hi,
Le Mardi 17 Juin 2003 20:46, Achilleus Mantzios a écrit :
On 17 Jun 2003, Rado Petrik wrote:
How I create table1 from other table2 .
cp table1 table2
create table table2 as select * from table1;
Another way would be:
select * into table2 from table1;
(See
42 matches
Mail list logo