2,536 reputation
721
bio website vancouverdata.blogspot.com
location Vancouver, Canada
age
visits member for 3 years, 7 months
seen 11 hours ago

MBA Finance
BA Econ
Data Mining
C#, Javascript, VB, SQL


Oct
22
answered One field with multiple values?
Oct
21
revised What are Measures and Dimensions in Cubes
added 62 characters in body
Oct
21
revised What are Measures and Dimensions in Cubes
added 62 characters in body
Oct
20
revised Fuzzy Matching with Postgresql 9.3
added 196 characters in body
Oct
20
answered Database with only text fields
Oct
16
answered Fuzzy Matching with Postgresql 9.3
Oct
9
awarded  Notable Question
Oct
3
comment How to represent directed graph with multiple parents?
Which db software?
Oct
1
revised How to save an interval of years in postgresql
deleted 3 characters in body
Oct
1
revised How to save an interval of years in postgresql
added 70 characters in body
Oct
1
comment Importing CSV into multiple tables using PostgreSQL
Your best bet is probably to import it into a temp table then move it to the two new tables.
Oct
1
revised How to save an interval of years in postgresql
deleted 237 characters in body
Oct
1
answered How to save an interval of years in postgresql
Sep
11
answered Can a PostgreSQL Trigger be used to ignore an insert?
Sep
11
comment Building dependence between regional data (Street -> City -> PostalCode -> Country)
@SeToY Ya I'm not saying it's not doable, it's just complicated, and there are lots of corner-cases to handle. Assume many-to-many relationships, not hierarchical ones and you'll be okay.
Sep
10
answered Building dependence between regional data (Street -> City -> PostalCode -> Country)
Sep
9
answered Database Design for Preserving Values and Additional columns
Sep
9
comment Database Design for Preserving Values and Additional columns
You should be afraid of EAV, if you ever need to analyze your data.
Sep
5
answered accessing fields of returned record object
Sep
3
comment Is Data Warehousing possible in MySQL and PostgresSQL
also see dba.stackexchange.com/questions/34172/…