duckpgq-extension
duckpgq-extension copied to clipboard
Allow expressions when creating property graph
CREATE PROPERTY GRAPH MovieRentals
VERTEX TABLES (
Customer KEY (Cust_ID)
PROPERTIES (First_Name, Last_Name, Gender),
Movie KEY (Movie_ID)
PROPERTIES (Title, Genre, Budget / List_Price AS Cost_Ratio)
)
EDGE TABLES (
Custsales
SOURCE KEY(Cust_ID) REFERENCES Customer (Cust_ID)
DESTINATION KEY(Movie_ID) REFERENCES Movie (Movie_ID)
PROPERTIES (Day AS Date_Rented) );
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.