246 reputation
18
bio website
location
age
visits member for 2 years, 3 months
seen Aug 26 at 20:57

Jul
15
awarded  Popular Question
Jul
2
awarded  Curious
Mar
11
comment Need some recommendations on organizing data
This is really a question of natural vs. surrogate key for primary key. You can see more here and the links pointed to from there.
Feb
27
awarded  Commentator
Feb
27
comment Table Field to Reference Field in Other Tables
@Zane: Care to explain?
Feb
27
asked Table Field to Reference Field in Other Tables
Nov
28
awarded  Popular Question
May
9
awarded  Yearling
Nov
30
accepted Load Numerical Column with Variable Comma
Nov
30
comment Load Numerical Column with Variable Comma
OK, this works; I ended up doing something similar before seeing your answer. I guess, at first, my brain had been looking for a way of using the format model to 'logically' say that the value may or may not contain commas.
Nov
29
asked Load Numerical Column with Variable Comma
Sep
5
accepted Regular Expression Difficulty
Sep
5
asked Regular Expression Difficulty
Aug
30
comment Using Multi-table Insert for Parent and Child Table
@VincentMalgrat: I'm inserting rows returned by a subquery. It is this subquery that determines the parent-child relationship; two insert statements wouldn't work.
Aug
29
comment Using Multi-table Insert for Parent and Child Table
@Phil: Yes I am.
Aug
29
asked Using Multi-table Insert for Parent and Child Table
Aug
27
comment Limiting Generated Sequence Values in Multi-table Insert
clever workaround!
Aug
27
accepted Limiting Generated Sequence Values in Multi-table Insert
Aug
21
comment Limiting Generated Sequence Values in Multi-table Insert
true, I'm not particular about that though. I just constructed this scenario as a MWE.
Aug
21
comment Limiting Generated Sequence Values in Multi-table Insert
What's wrong with mixing currval and 'nextval`?