阅读背景:

将“WHERE”参数传递给PostgreSQL View?

来源:互联网 

I have a rather complicated query on my PostgreSQL database spanning 4 tables via a series of nested subqueries. However, despite the slightly tricky looking appearance and setup, ultimately it will return two columns (from the same table, if that helps the situation) based on that matching of two external parameters (two strings need to match with fields in different tables). I'm fairly new to database design in PostgreSQL, so I know that this seemingly magical thing called Views exist, and that seems like it could help me here, but perhaps not.I have a rather complicated query on my Postgre




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: