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 ha
[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 Eis
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 th
Hi,
I’ve a table containing
a CIDR field.
I’m using an EJB to
create a new record in this table.
I don’t 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 ex
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
Ð ÐÑÑ, 12.10.2004, Ð 15:24, Markus Bertheau ÐÐÑÐÑ:
> Is the order of the rows guaranteed to be preserved?
Neil clarified on IRC that
- there is no interface guarantee
- in the current implementation the order is preserved
- a future implementation is likely to change that
Thanks.
--
Markus Ber
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]>
---(
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
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 ):
