Gang,
I've got what I think should be a pretty simple problem- I just can't
figure out how I'd do it. Heck, I can't even figure out how I'd search
for an answer to this problem.
I've got 2 tables: member and member_attr
Member is just a standard entry for a member. Very simple:
table member
Vishal Charan (IT Fiji) wrote:
please remove my email from your database contacts.
Best Regards,
*_Vishal Charan_*
*IT Support *
*Courts/Homecentres*
Is this another worm that attempts to lower the internet traffic by
requesting to remove people from mailing lists? It's the 5th or so
"unsubs
Kurt,
> I've got what I think should be a pretty simple problem- I just can't
> figure out how I'd do it. Heck, I can't even figure out how I'd search
> for an answer to this problem.
This is an old common SQL problem ... the "crosstab" table. There are 3
standard ways to solve it, depending
On Thursday 09 October 2003 18:14, Josh Berkus wrote:
> Kurt,
>
> > I've got what I think should be a pretty simple problem- I just can't
> > figure out how I'd do it. Heck, I can't even figure out how I'd search
> > for an answer to this problem.
>
> This is an old common SQL problem ... the "cro
Marek,
Not sure but, try switching the lines
db_data.mda_mod_con _CON,
db_data.set_mda_fue _FUE
with
db_data.set_mda_fue _FUE,
db_data.mda_mod_con _CON
so there query is:
SELECT
_CON.con_id,
_MOD.mod_ty,
_VER.version,
_YEA.year,
_CON.dri_id,
_CON.man_cod,
_ENG.eng_p
> > SELECT
> > _CON.con_id,
> Please make sure you get the quoting right regarding table
> names. PostgreSQL will fold _CON into _con unless quoted
> "_CON". So, it may be that you created the table with quotes
> ("_CON"). Now, in your query you don't use quotes and thusly
> it is looking for
Hello,
I'm in the middle of the migration process from MySQL to PostgreSQL and
I cannot understand why this query isn't working (in MySQL it's working
fine). PG returns: ERROR: Relation "_con" does not exist
This is my query:
SELECT
_CON.con_id,
_MOD.mod_ty,
_VER.version,
_YEA.year,
_C
On Thu, Oct 09, 2003 at 20:52:58 +0100,
Marek Lewczuk <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm in the middle of the migration process from MySQL to PostgreSQL and
> I cannot understand why this query isn't working (in MySQL it's working
> fine). PG returns: ERROR: Relation "_con" does not exist
