A tested example in Python :
Basically it counts the \t and accumulates the lines until it has enough
and then prints the line.
Note : as an exercise you could add a test so that there are exactly
(columns-1) delimiters and not =(columns-1).
def grouplines( in_stream, columns, delimiter ):
Hello !
I am trying to find some informations about the SQL command create
synonym.
The command create synonym does not exit in the Postgres database.
I had tested with the latest version (postgres8.0 beta3) and this command
is not present.
I supposed that this command create synnonym is an
Hi,
When I call a PL/pgSQL function that looks roughly like the following:
...
FOR x IN SELECT ... ORDER BY ... LOOP
RETURN NEXT x;
END LOOP;
RETURN;
END;
Is the order of the rows guaranteed to be preserved?
Thanks.
--
Markus Bertheau [EMAIL PROTECTED]
Theo Galanakis [EMAIL PROTECTED] writes:
As you can see row 2 has a value that holds a CR value which ends up
wrapping around onto the third line. Postgres copy command does not like
this and mysql is unable to replace the value with another type of
delimiter, like a \r.
So I gather I have
This is untested, but it might be enough to get you started:
SELECT namecounter
FROM name n
WHERE NOT EXISTS (
SELECT 1
FROM name
WHERE hh 0
AND famnu = n.famnu
)
GROUP BY famnu
HAVING birthdate = min( birthdate );
What I'm trying to do here is grab all families
[EMAIL PROTECTED] wrote:
Could you say if this command will be implemanted in a future version
of a postgres database ?
I'm not currently aware of any concrete proposals to implement this
feature, but previous discussion has not shown any strong resistance
against the concept.
--
Peter
Title: RE: Export tab delimited from mysql to postgres.
Thankyou all for your advice,
Looking further into the issue I have realised that data and formatting lines are denoted by the same CR/LF symbols. So if I where to replace all CR/LF symbols it would create a file with one line... I
Hi,
Ive a table containing
a CIDR field.
Im using an EJB to
create a new record in this table.
I dont know how to pass
the CIDR value. I tried by String but I get this error :
javax.ejb.FinderException: Find failed: java.sql.SQLException:
ERROR: operator does not exist: cidr = text