2,441 reputation
621
bio website vancouverdata.blogspot.com
location Vancouver, Canada
age
visits member for 3 years, 6 months
seen 4 hours ago

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


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/…
Sep
2
answered Best approach for Legal/Natural can have many Orders
Aug
30
revised Many-to-many relationship with attributes
added 26 characters in body
Aug
30
answered Many-to-many relationship with attributes
Aug
30
comment Need Help verifying tables and creating the the junction tables needed for a Bank project
Make sure you read up on The Party Model, table inheritance. Individuals and groups should inherit from same parent.
Aug
29
revised Is there any difference at all between NUMERIC and DECIMAL?
deleted 1 character in body
Aug
29
answered Is there any difference at all between NUMERIC and DECIMAL?
Aug
28
revised Is normalization advisable on transactional data?
deleted 81 characters in body
Aug
28
answered Is normalization advisable on transactional data?
Aug
28
comment API on top of postgresql
Hibernate Tools Reverse Engineering + Spring Data JPA + Spring Data REST would get you a JSON REST API in several minutes.
Aug
27
answered PostgreSQL equivalent of MySQL query variables?
Aug
27
comment How to model mappings at various levels
Why don't you use a database with built-in hierarchical roles and not re-invent the wheel?
Aug
27
answered Query to return output column names and data types of a query, table or view
Aug
26
comment Does PostgreSQL allow multiple grantees in GRANT commands?
@vfclists yes. This would be valid: grant select on a_table to group1, group2, group3